This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is it possible to "push" the headings down into the first row of data? so then the first row of data would become 2nd etc.
I know I can do this at the start with the input tool, but later on in my workflow I'm creating several columns which headings I would need in that first row, so ideally I would do this at the very end when my dataset is complete(and all the extra columns are added).
The new headings don't matter to me, it can be whatever as long as I can have my current headings in the first row.
I'd try using a field info tool to get the names of the fields. Then I'd take that data and put a record ID on it. Then you can crosstab it and have the record ID as the header and the data as the NAME. You can use a dynamic rename on the output and use a formula to put "FIELD " in front of the field name. Now you have a row of data to add to your original data.
Put this into a UNION (connection #1) and set the union to always use connection #1 first. Put the original data into the union as #2. Have the union configured for field position (not auto by name).
That's what I would try to solve for your problem. Please let me know if it works or if you find a more elegant solution.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.