How can I Merge the 2 tables (Paid invoices and Unpaid invoices) to one main case table. After uploading the above files.
Page 1 / 1
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.
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.
when i use union im getting 0 rows effected, but i want data of both tables in on main case table.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.