Remove unwanted row

[Sengkiat28]

Hi,

I'm currently facing bottleneck with my workflow and hope you guys can lend me a hand. High level understanding, my workbook contains 500 tabs with identical data and I'm trying to consolidate all the tabs with 'dynamic input' tool and perform subsequent reconciliation work. 

The following is example of data:

Price
Product A
Product B
Product C
Product D
Design
A
B
C
D
Payment
Credit Card
Cash
Volume
Product A
Product B
Product C
Product D

After consolidate the data from 500 tabs with dynamic input tool, I would like to remove all the rows corresponding to Volume- Product A,B,C,D. I have considered to use the following tools:

a. Filter tool- not suitable because I want to keep rows corresponding to Price- Product A,B,CD

b. Unique tool + Record ID tool + Filter tool - not suitable because there are more than 10k rows after I consolidate the data with dynamic input tool,

c. Cross-tab- not suitable because again, it has more than 10k rows

Note: I tried to use excel and perform bulk rows removal by coping all the tabs. However, the rows associated to Volume -Product A,B,C,D are not consistent across the workbook and this is not feasible too.

Do you guys have any recommendation?

[TimN]

If I understand the question 

Use the Multi-Row tool to add a column to flag all Volume- Product like this:

Then filter out Vol

[Sengkiat28]

Hi Tim,

Thanks for your response. That probably works.

Can you please advise the configuration and the expression? Not quite familiar with the tool...

[TimN]

Here's a picture.  Trying to upload it

[TimN]

Sample WF.  Hope it helps!

[Sengkiat28]

Hi Tim, it all the remaining rows were impacted by the expression, as you can see from my attached file.

Can the formula expressed in a way that only catch the rows/items associated with Volume so that I can use filter tool to push out those rows?

Appreciate your response.

[TimN · Accepted solution]

Something like this I think if the blank lines are consistently there.

IF [F1] = 'Bunkered Sales (Vol)'
THEN [F1]
ELSEIF [F1] = Null()
THEN
Null()
ELSE
[Row-1:New Field]
ENDIF

[TimN]

Also, If Bunkered Sales data is coming from specific Excel files then add the Output File Name as a column.  You could then filter on that.

[TimN]

@Sengkiat28 If any of the responses helped you, kindly accept the solution(s) for future reference.  

Thanks.

[Sengkiat28]

Hi Tim, it works perfectly! Thanks so much for your help.