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

[delalma]

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.

[apathetichell]

I thought I understood what you want but then I saw you are using a file browse tool so now I'm a bit confused... are you extracting the value you are searching for from the name of the file selected in the file browse tool? If so what's the format?

I used a text input tool which searched for rows below a value inputed in a text tool but that might not be what you want?

[atcodedog05]

Hi @delalma 

Is it always in the same column?

[atcodedog05]

Hi @delalma 

Here is how you can do it. I am assuming data is anywhere even in middle

Input:

Workflow:

1. Using data cleanse tool removing Null rows and Null columns

2. Using dynamic rename tool renaming based on the first row.

3. Using select tool to select only column.

You can convert this to an app.

Hope this helps 🙂

[delalma]

Thanks. The file browse tool is connectioned to action tool which is connected to an input data tool. The the user give a file path which is fed into the input data tool. And then comes the extraction of the data. By the way I am not able to read your file because of the older version of my software. Thanks

[delalma]

No it is not always the same column. I tried your answer without success.

[apathetichell]

Try this version of the workflow - it's saved for an older version... or  you can read @atcodedog05 's walkthrough on how to open newer workflows...

Honestly - I am a bit confused. I get the file browse opening the new file - but are you searching for a user determined string or are you always searching for the same string and the file is changing? If it's the later it's a fairly straight forward approach which I think @atcodedog05 sketched out - but if the user is also entering something via a text box then you'd have two interface tools - one for the file and one for the search term...  which do you need?

[delalma]

Thank you for your answer. As you mentioned I am  always searching for the same string and the file is changing. Please see the workflow I tried based on @atcodedog05 help.

[delalma]

I am still on ALteryx 2019, so could not use the remove empty rows feature...

[atcodedog05]

Hi @delalma 

Luckily data cleanse tool is a macro hence I can share it with you.

I have attached a packaged workflow with data cleanse tool macro included. You need to follow this guide to downgrade the packaged workflow. https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...