Skip to main content
How can I Merge the 2 tables (Paid invoices and Unpaid invoices) to one main case table. After uploading the above files.

Hi Parvathi,

 

You can use the function UNION_ALL in a transformation in Data Integration, and create your new table from this union. See here for more info.


okay, thank you @charlie.kante11.

 


I have few doubts also, can i ask you? @charlie.kante11 


Hi Parvathi,

 

You can use the function UNION_ALL in a transformation in Data Integration, and create your new table from this union. See here for more info.

Hy @charlie.kante11 

when i use union im getting 0 rows effected, but i want data of both tables in on main case table.


Reply