Renaming a field when its respective name is stored in the next column to the right?

[wtan]

I know the title might sound a bit confusing, so I'll share my workflow and try to explain more here.

In essence, I'm trying to flatten a nested XML into a table. I've managed to get it 90% there, the only problem left is that my field names are stored in another column. For example, "field" should have the field name "date", but "date" is stored in the next column to the right named "field_id". Similarly, "field_2" should be named "location" and "location" is stored in the column to the right ''field_2_id".

I tried using cross-tab, but that didn't quite work out. A multi-field might need to be used, but I'm not too familiar with renaming columns with multi-field or if Alteryx supports column indexing.

If anyone has any tips, I'd greatly appreciate it. Thanks!

[Qiu · Accepted solution]

@wtan 
I hope this works for your bigger data dynamically.

[wtan]

Thanks for the quick response. Works perfectly for my actual dataset!

[Qiu]

@wtan 
Glad to help and thank you for the accept mark.