Best way to join to tables on a LCA

Solved826 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

1 Answer

1
21.19K 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
Ana Pinho [SLC] [DevOps Advocate] commented

Thank you Miguel! That’s exactly what I needed