Merge more than just 2 column

Hi,

I have 10 columns that i want to merge become only just 5 column

i already use column merger but that’s only merge 2 column

image

so this is the result ::

how can i merge the rest column ?
can anyone helped me ?

Thanks,

First use the Column Rename node to give the columns that should be merged identical names, then use the Concatenate node.

Hi,

When i use the Column Rename : there’s error

image

Thanks,

Oh sorry my bad. First split the table with the Column Splitter, then do Column Rename, then Concatenate.

Hi,

Wow…it works , but why there are blank rows ? if i want to delete that blank rows, what should i do ?

image

Thanks,

I would suggest creating a meta table that specifies which Columns are to me merged

merge1 | merge2
Col0 | Col5
Col2 | Col7

and then use a loop to combine them all.

Hi,

I use Row Filter, exclude rows by attribute value. Only missing values match.

Thanks,

1 Like

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