How do I select the last 34 columns of my file(excel) without using the Transpose or CrossTab tool?
Solved! Go to Solution.
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
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
Total number of fields - 74
I cannot use Cross Tab + Transpose because the data is huge and also it isn't that clean.
Have you read this thread?
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.
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.