Promote a Row to be a Column Name

Hi team,

I have a workflow very complicated, I’m working on it, but now I have the column names in the second row after use transpose node, so, how can I promote this row to be a column names

image

Thanks in advance!!!

Hi. I guess when you say “column names in the second row” you mean the first row of the table (under the column names?). If so, I created a metanode (now called a component) that promotes the first row of a table to column names. I use a Row Splitter to separate the first row from the rest of the table. Then I use a transpose node on the row with the col names to create a lookup table of column names. This is then fed into the Insert Column Header node. Please see attached workflow.
Hope this helps.
-Don
image
promote first row to header.knwf (12.3 KB)

14 Likes

OMG!!! Thank you very much!!! Works perfectly!!!

3 Likes

HI,

this is what I do to get any row become a column names.

image

In the RowID Node select de colum yo want to become column names.

Check it out¡¡¡

Regards

4 Likes

Nice idea!!! thanks a lot!!! :wink:

1 Like

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