Take Field Names from Multiple Columns

[kpurba94]

Hi,

I have some data like below.

1	2	3	4	5	6
8=FIX.4.2	9=0	35=8	6=0	14=0	15=USD
8=FIX.4.2	9=0	35=8	6=0	14=0	15=USD
8=FIX.4.2	9=0	35=8	6=0	11=DTB137920190625151556932S/AMZN	14=0

I want to take the value before the "=" and make that a column header and also align each row to the respected columns as such.

8	9	35	6	11	14	15
FIX.4.2	0	8	0	Null()	0	USD
FIX.4.2	0	8	0	Null()	0	USE
FIX.4.2	0	8	0	DTB137920190625151556932S/AMZN	0	Null()

Any help is much appreciated!

Thanks,

Karan

[JosephSerpis · Accepted solution]

Hi @kpurba94 I mocked up a workflow let me know what you think?

[JosephSerpis · Accepted solution]

Hi @kpurba94 I revised the workflow slightly to give the order you described in your output.

[kpurba94]

Hi Joseph,

This is exactly what I was looking for. Thanks for your help!

Regards,

Karan