Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Header to row

LS1700
5 - Atom

Hello,

 

I have a DB connection, with some fields that change every month. 

I would like to:

1- copy the header and input it in the first row

2-rename the header with some standard name, such as F1,F2,...

 

Any idea?

please keep in mind I am using a DB connection, so "first row contains data" does not work!

 

regards
LS

 

 

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

Try the attached.

 

Use a field info tool to get the names.

Create a new field name F1, F2, ... etc

Cross tab the results

 

Then use a Union tool in position mode and I think you are there.

 

 

LS1700
5 - Atom

Yes, good tip.

 

 

thanks

 

Labels