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

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.

test1.xlsx

Input

Data Investigation

Accepted answers

All comments

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?

text box finder.yxzp

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 🙂

excel id.yxmd

test1 (1).xlsx

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?

text box finder.yxwz

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.

Capture.PNG

delalma

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703