Header to row

[LS1700]

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

[jdunkerley79 · Accepted solution]

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]

Yes, good tip.

thanks