Find 2 values in each Line regardless of column name or no.

[PassION_es]

Hello Alteryx Community,

I would like to know if Alteryx has the capability to find values in each of the line item (condition 1 & 2 are both present) regardless of what columns they are located (because the columns is dynamica). That is, as long as all conditions are present, then that line item will be captured in the workflow and the output is to consolidate all those filtered/selected line items in their corresponding tab/sheet.

Attached here, is a sample of input and output (sheets highlighted in red).  The "Condition" sheet name contains the values or conditions that need to be present in each line.

[PassION_es]

hi @jdminton. Thanks, it actually works on all tabs except for LOB. For this reason, what I did is to use both of your workflows, the former one to output the LOB and the rest of the tabs will be output by the most recent workflow. And then I used union tool to consolidate them in one file. Though im still trying to figure out possibility to perform all steps in to one workflow. But for me, these workflows really solved my problem for the time being.

[jdminton]

The LOB only required the one criteria, which you mentioned two in the original post. I thought I included something for handling that, but maybe it just doesn't work with the actual data. You could default to LOB for the unassigned and do a quick formula to validate that only one criteria exists. I just wanted to make sure there was some mechanism to catch those that should be assigned elsewhere even if the criteria was missing (i.e. the first one in your sample). Hopefully, you can do this. Feel free to post back if you're having other issues.

[PassION_es]

Oh that makes sense. Thank you.