Best way to join to tables on a LCA

Solved170 viewsLCA low code app
0
0 Comments

Hi dojo,

I have table A, that has two columns (ID (string), Label (string)) and table B with the same two columns.
What is the best way to create table C, on a low code app, that joins the two tables.

Table C should have the rows of A and B and just the two columns (ID, Label).

Thank you,
Ana

Ana Pinho [SLC] [DevOps Advocate] Selected answer as best 25th September 2024

1 Answer

1
15.99K 1 Comment

Hi Ana,

A possible option is using an outer join operation. After the outer join, you can use column manipulation operator (concatenate) to create columns based on the result of the outer join. See example below:

Hope it helps.

Ana Pinho [SLC] [DevOps Advocate] Posted new comment 25th September 2024
Ana Pinho [SLC] [DevOps Advocate] commented

Thank you Miguel! That’s exactly what I needed