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

Example.yxmd

DataNath

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.

Set column header from another field.yxmd