HOW TO CONCATENATE TWO COLUMNS AND GET IT AS A NEW COLUMN IN DATA TABLE?

hi @hacky
Here is a sample xaml zipped folder that could resolve your issue
Its resolved
concatenate_modified.zip (13.5 KB)

I have also added you with setordinal to place the concatenated column in the excel wherever you want by mentioning the index of the column, here in this xaml i have set as 0 index so the concatenated value will be there in first column of sheet2…

Hope would help you with your issue

Cheers kindly let know if it works

4 Likes