Hello there. I have three data tables. I want to combined them to a new datatable for my further handling. I tried Join & Merger datatable function but they didn’t work because there’s no common column for matching.
Thank you for your help. I have attached the picture for your reference.
HI ppr, I was trying this but encountered some difficulties. Firstly, your example is only for two data tables. Does it mean I should first do it with dt1 & dt2 for a desiredDT, then do it with desiredDT & dt3 for new desired DT?
Moreover, it’s showing the error when I used the invoke method activity.
Ok, I tried it with dt1 and dt2. The output is indeed a lot more than 4 rows. Just like what I mentioned earlier. I don’t need 4 rows of each name. Could you please advise?
Hi Peter, could you see the photo already attached in the first post? It showed the 3 data tables on top and the desired output I want below on the same photo.
Please let me know if you couldn’t see it. Thank you.