Dynamic field to split

Dear Alteryx community,

hope I have not overlooked a solution on my question.

I receive a txt file every week. For this I have build a workflow that works all fine. But the "Field to Split" in the "Text to columns" tool is dynamic.

Some information of the "Field to Split" changes every week.

At the moment I just replace the old field by new field.

Can this process be built into the workflow with some tool I overlooked?
I have enlcosed a picture illustrating my question.

thank you for your help

best

Crete

dynamic Field to Split.png

Preparation

Accepted answers

unknown

Here is an example I was talking about, this should work for you.

Sample.yxmd

All comments

unknown

Field to split should be based on the rows. I would personally put that column header into the rows. You are splitting the rows into additional columns, that will not work when that value is already in the column header. Push it down to the row level and call that field a generic name (Split Column for example). Then there is no need for a dynamic field.

Alternatively, you can use a macro with a control parameter that updates that value in the stream each time and that will solve your dynamic issue.

Crete

Dear rayn_lambert,

thank you for your answer.

The file I receive is a txt file and I want to split into columns, not rows. The file has one column and many rows. The issue is that the header of the the txt file changes every week. And this is the field I use to split into columns

When I try to work the the makro I cannot as it does not recognize the txt file.

thank you

Crete

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703