How do I change the default headers to Field X?

I have data which has a few rows of headers. The first row of headers is 'USD' and as you can see from the screen attached, Alteryx is renaming these as USD1,2,3 etc

How can I get the headers to continue as F5,F6,F7 etc and for the USD header to become a data row (so I can deal with it separately).

Thanks

Dynamic Processing

Accepted answers

Felipe_Ribeir0

Hi @Carluccio555

You could select the option First Row Contains Data on the input tool config

All comments

Felipe_Ribeir0

Hi @Carluccio555

You could select the option First Row Contains Data on the input tool config

KrishnaChithrathil

@Carluccio555

I donno whether I understood it in the right sense. Is this the way you want your output to look like?

KrishnaChithrathil

@Carluccio555

I did something like this with my understanding. 😄 But I seriously expect a better workaround for this.

*If this is not what you expect, please provide us a sample output.

How to change default headers to Field X.yxmd

Carluccio555

Thanks everyone!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167