Convert 31 column table to 2,046 columns

KNIME Analytics Platform
6

Hello @bmclain,

for your data transformation you can only use Pivoting node if you add group and sequence columns to your table. Avoiding loop might be good idea if you are working with 10+ million of rows. See here how to simply add group and sequence columns to your table:

And here is workflow with Pivoting node under assumption you have already added these columns:
convert_x_cols_many_cols_ipazin.knwf (21.0 KB)

Regarding writing to Teradata you can explore these nodes:

Br,
Ivan

1 Like