6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Select Columns For Sampling

sanketkatoch05
8 - Asteroid

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

7 REPLIES 7
shreyanshrathod
11 - Bolide

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
8 - Asteroid

Hi, @shreyanshrathod 

 

Can you help me with the formula? 

shreyanshrathod
11 - Bolide

@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
8 - Asteroid

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

shreyanshrathod
11 - Bolide

@sanketkatoch05 ,

 

[Fieldnumber]  >= 40.

 

This should work.

apathetichell
15 - Aurora

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
8 - Asteroid

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. 

Labels