Select Columns For Sampling

[sanketkatoch05]

How do I select the last 34 columns of my file(excel) without using the Transpose or CrossTab tool? 

[shreyanshrathod]

Hi @sanketkatoch05 ,

You can definitely use "DYNAMIC SELECT" tool with "Select with a formula" configuration to achieve desired results.

Hope it helps.

Regards,

Shreyansh Rathod

[sanketkatoch05]

Hi, @shreyanshrathod 

Can you help me with the formula? 

[shreyanshrathod]

@sanketkatoch05 ,

We need to know exact number of fields available in the excel file then.

If not, combination of Transpose, Crosstab and Join is the best way to go.

Regards,

Shreyansh Rathod

[sanketkatoch05]

Total number of fields - 74 
I cannot use Cross Tab + Transpose because the data is huge and also it isn't that clean. 

[shreyanshrathod · Accepted solution]

@sanketkatoch05 ,

[Fieldnumber]  >= 40.

This should work.

[apathetichell · Accepted solution]

Have you read this thread?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pull-in-the-last-10-columns-from-an-ex...

the key with the transpose/crosstab solutions isn't to read in the data first - it's to read in the excel column headings and then to pull in the data once the range is clarified.

[sanketkatoch05]

Hi @shreyanshrathod , 

I used the FIELD INFO + SAMPLING method instead, but I really appreciate the time you took out to help me. 

Thank you so much.