Concatinate column irrespective of column headers

Hi all,
Is is possible to concatenate columns from two files irrespective of their column names.
as I have two files both with same number of columns and I want to append those one after another but due to different column names it gives me additional number of columns in output file…
Both file have 120 columns each and expected result after concatenation I expect 120 columns only…
Anyone here please help…

Thanks,
Mrunal

Hi,
You can first extract the column names from the table you want have the names from for the concatenated table using Extract Column Header, then in both tables rename the columns using Column Rename (Regex) with default pattern and replacement value “X”. Now concatenate, extract column header again and insert the original one back by creating a lookup table with the originally extracted columns using Transpose, Column Appender, and Insert Column Header.
Kind regards
Alexander

2 Likes

Thanks :slight_smile:

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.