This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am using the Batch Input Macro from this post (https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480) to input one tab from 36 Workbooks. The tab is not the exact same in each workbook, hence the need for the batch macro.
I want to modify the Macro to look down the rows of the tab, & to select only those records that occur below a specified piece of text...
I want the modification to be made before the Macro Output tool like in the below screenshot where I added the "Select Records" tool
Go to Solution.
Go to Solution.
I would just add a new field called "indicator" with the MultiRow Formula Tool that looks something like:
IF CONTAINS([Field1], 'select from here')
Then, you can perform a filter on indicator=1, and just remove the first row. (or do IF CONTAINS([Row-1:Field1], 'select from here).
The important bit here is that you configure the MultiRow Formula Tool to set "Values for Fields that don't Exist" to "0 or Empty", so that everything except for the desired rows will be 0.
Let me know if this helps or I've missed something,
Thanks very much for your help!
No problem, glad I could point you in the right direction!
Hi, I found this solution useful but I got stuck in another one.
I have attached a workflow excel where I only wanted to select the records/ mark the indicator to 1 from "start from here" to "end here", which are being repetitive in the sheet.
I have tried by using another Multi row formula where using IF ELSE statement to achieve this but couldn't help much.
appreciate any help in this regards.