Selecting the input with specific header

Question

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 A12345786  Product B5564885786 Product C 222356856

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

binu_acs · Answer

@Rafiuddin_333 another option

product_27032025.yxmd

flying008 · Answer

Hi, @Rafiuddin_333

You only need input all then filter the unless rows.

leonhekkert · Answer

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.