Name columns based on range of list and insert data with delimiters

Hi Community

I am trying to structure some data, which is easily done in Excel, but difficult for me to do in Alteryx. I would like the steps done in Alteryx, as another part of the flow is generated in Alteryx, so a simple "Run" would be easier than navigating multiple programs.

I have an input file, where both the desired headers and the data are in the same list. Furthermore i would like to add some special headers, which is not in the list.

In excel i can simply transpose the list of headers (data between "Start-of-fields" and "End-of-fields") and add the headers that i know is missing as the first 4 (ISIN, TBD, TBD, Country).
Furthermore i can use the "text-to-columns" on the data fields (data between "Start-of-data" and "End-of-data") to split it into multiple columns.

However, the solution in excel is very manual and the solution that I can create in excel does not incorporate if the amount of headers and data fields varies.

Thank you very much.

Test workflow.yxmd

Developer Tools

Input

Regex

Output

Custom Tools

Transformation

Data Investigation

Accepted answers

Sebastiaandb

Hi @Lauritsjust ,

Hopefully this comes close enough to what you want to achieve :-) (see the attached workflow)!

In case you always have the same set of fields (in the same order) you can just replace the upper stream and connect a text input tool with all fields to the union tool and set the order by on the stream with the text input tool :-). In that way it forces the data fields to fit to the order of the fieldnames stream.

Greetings,

Seb

Columns.yxzp

Felipe_Ribeir0

Hi @Lauritsjust

One way of doing this:

Name columns based.yxmd

All comments