Selecting the input with specific header

[Rafiuddin_333]

Hello All,

I have a data set which is not constant and keeps on changing and it looks like this for example

Product codes
Product A
123
45
786
Product B
556
4885
786
Product C
2223
56
856

Question: Is there any way that in Alteryx to select the data only from "Product C" (Based on above example). The data keeps on changing so I cannot use "Input tool parameter > Select from line item"

Thank you very much for your time and effort

Regards,
Rafi

[leonhekkert]

Are you always looking for info on Product C? And can the numeric values be summed, or do they represent different kind of measures?

What you could do is use a multi-row tool to figure out which rows belong to which product. 
I created a new column in the multi-row called 'ProductNr' and usesd this expression: If Contains([Product codes], 'Product') Then [Row-1:ProductNr] +1 else [Row-1:ProductNr] endif.

Then you can filter, join or whatever you like to do then.

[flying008]

Hi, @Rafiuddin_333 

You only need input all then filter the unless rows.

[binuacs]

@Rafiuddin_333 another option