Change column heading with data from another column

[Verakso]

Hi Community.

I am struggling a little bit with this.

My data looks like this:

What I am trying to figure out is how to change the column name JSON with the FieldName opening_hours so it looks like this:

The really tricky part is, that I might end up with different FieldNames, and it would be nice if it dynamicly could handle this, so I end up having RecordID, opening_hours, addition_records, ect.

How would you do that?

(Obviously I have tried searching the community for this. but the examples I found I couldn't crack them to give me the output I want).

Br(ツ)

Thomas

[DataNath · Accepted solution]

Hi @Verakso, you'll be able to do this via the Cross-Tab tool. If you group on your RecordID field and then just use the FieldName column as your header lookup - even if you have more than one FieldName, this will split out as you expect. The value is then just your JSON field.

I've just added a Sort tool after to retain the original RecordID order! Hope this helps.

[Raj]

@Verakso Crosstab tool should work best in this case.
please check the attached examples in designer for better understanding.

[Verakso]

It has been a long day, thanks for the obvious solution

/Thomas