Select Columns For Sampling

sanketkatoch05

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

Common Use Cases

Dynamic Processing

Data Investigation

Accepted answers

shreyanshrathod

@sanketkatoch05 ,

[Fieldnumber] >= 40.

This should work.

apathetichell

Have you read this thread?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pull-in-the-last-10-columns-from-an-excel-spreadsheet/td-p/750326

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.

All comments

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?

apathetichell

Have you read this thread?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pull-in-the-last-10-columns-from-an-excel-spreadsheet/td-p/750326

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703