Reverse Generic Load?

[Crprtslv]

Greetings,

I would like to set up my data that is like the Input to be in the format of the Output. How can this be achieved?

[jwjackso]

I think you are looking for the crosstable function.

[Crprtslv]

Yes that should work. I forgot to mention that it should account for additional columns added to the right. Is there a way for additional columns added to the right in the future to be loaded automatically?

[jonathandienst · Accepted solution]

If they are just additional data, then use  a LOAD* to collect all fields:

CrosssTable(label, value, 1)
Load *
From ...

If they are new attributes, then adjust the load so they are listed first and amend the crosstable attribute count:

CrosssTable(label, value, 2)
Load Key, newAttribute, Color, ....
From ...