Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi All,
i have two tables for eg:
Table 1 :
RULE | BP1 | BP1_PK |
1 | 2 | 3 |
table 2:
RULE | BP2 | BP2_PK |
1 | 5 | 6 |
i need to append these two tables to get the output as:
RULE | BP1 | BP1_PK | BP2 | BP2_PK |
1 | 2 | 3 | ||
1 | 4 | 5 |
Any help would be appreciated.
Thanks in advance
Operating system used: windows
Hi @shahas71 ,
You could achieve this by using a Stack recipe. On the Selected columns step --> Columns selection, select the Union of input schemas.
P.S. I guess that in your final table the values 4 and 5 should be 5 and 6, respectively, right?
-Konstantina
Hi @shahas71 ,
You could achieve this by using a Stack recipe. On the Selected columns step --> Columns selection, select the Union of input schemas.
P.S. I guess that in your final table the values 4 and 5 should be 5 and 6, respectively, right?
-Konstantina
Hi @konathan ,
Thanks for the quick reply.
This was the answer i was looking for.
Thank u so much 🙂
Glad I could help! 😊