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 

Hy @charlie.kante11 

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