We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Get all value below a given string from random data from the Input data tool

delalma
7 - Meteor

This is my first post. I have an input file from an interface file browse tool for which I want to extract only all value below a defined header named "Excel Company ID". The header can be anywhere in the sheet, not only in row 1. I tried to use the Multi row tool by reading similar post without success. Let me send a file which can be an input. Please take into account that the cell "Excel Company ID" may be anywhere. Thank you in advance for your help.

10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

@delalma 

 

Alternatively, you can place all these files in the same folder and run it. It might work. Let me know if you face any issues.

 

Hope this helps 🙂

Labels
Top Solution Authors