Data360 Analyze

Hi,

Some data in my flow looks like this:

The only field that surely exists is the "MAIN" field. Other fields' names depend on the input, which I can't predict.

I want to reshape it into this:

How can I achieve this?

The only solution I could think of is use the "Pivot - Names to Data" Node. I need to exclude the "MAIN" field from the pivot fields. But I don't know how to.

One work around I could think of is exclude the "MAIN" field and do a wildcard pivot. Then I'll get 2 tables:

and

Is there a fast way to join the two tables?

(Note that this "workaround" works because my original table has only 1 row)