Automatically select first n columns as key fields for transpose

Hi all,

Is there any way I could set Alteryx to select the first n columns (first 3 in the attached example) for transposing?

Problem is that my data source is a pivot table which has dates in column names. The dates change from one week to another and I want to be able to keep the first n columns(which remain unchanged from one week to another) as key fields and the rest as data fields.

Test workflow.yxmd

unpivoted.xlsx

Pivot table dummy data.xlsx

Dynamic Processing

Accepted answers

jdunkerley79

Sorry misread - I thought first three changed.

All you need do is make sure 'Dynamic or Unknown Fields' is ticked in the Transpose

And set the Warning to Ignore Missing Fields.

Should then be fine.

Attached you sample update to do this.

Test workflow.yxmd

All comments

jdunkerley79

Use a dynamic rename to relabel the first 3 columns with a text input to give a set of names.

Do the transpose

Then use a Field Info to get the original names and relabel first three again.

Attached a sample.

Test workflow JD.yxmd

Cristian_Ionescu92

I am not sure if I follow.

The idea is that I am not bothered by the first three columns, which remain always the same, but by the next 7 ones which every week have a different name.

Could you, please, provide more information?

JohnY

works like a charm man! very nice

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703