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

I think this is doing what you are requiring. There are a few in your example output for LOB that did not match the input, but I don't know if that is because LOB is only requiring 1 criteria even though those input lines matched 2 criteria for a different categorization. I did not have them add to LOB because they matched another and did not think you'd want the duplication, but perhaps for your business case, you do want that duplicated. See attached.

@PassION_es Sorry about that. I had tried a simple way to work around the records that only matched the one condition (LOB). I switched it up a bit here. Try this workflow instead. There is one record in your sample, the very first, that does not meet the criteria for any, so it is assigned to the No Match tab in Excel.

All comments

binu_acs

@PassION_es Can you explain the logic for the LOB tab has 6 records populated?

Hi @binu_acs ,

Apologies, I updated the file to reflect the correct output for LOB.

Thanks

Search_and_Filter.xlsx

binu_acs

@PassION_es would you mind explaining the logic of any one of the tab? I wan trying to understand the requirement but not getting it.

@binu_acs -The logic is that I do have thousands of datasets in this input file and also around 20 or more columns and I am trying to use two or more filter tools however, the filter values are not always permanent, meaning it can change the next month, as well as the column no. or column name. So, as an alternative, I am asking the community if Alteryx can at least search for the 1st filter (which is in condition 1 column), then the next filter (which is in the 2nd condition column). If both or if all is present, then it will be captured. In the first tab name (which is the "LOB"), there is only one filter that needs to be there in order for it to be captured and output in the LOB sheet.

I hope this clarifies. Thank you in advance.

Hi @jdminton , thank you. This workflow is what I am looking for. For the LOB, it is correct that the workflow will not do any duplication. It was just that I have not think of this possible duplication when doing the dummy input file. Thank you.

Great to hear! It should work fine as is, but you might be able to modify once you are plugged into actual data to shorten the workflow a bit.

Hi @jdminton , actually when i plugged to the actual data with many more than 20 fields/columns, there were only 3 tabs (out of 6 tabs) created. The missing results of 3 tabs were output to the "NO MATCH" tab. Those missing tabs have the same criteria located in the same fields (condition 1 and 2) with that of the INFRA tab.

Here are the missing tabs:

Chief Controls

ECR+SPCM

CAO

There should be the same total of outputs and inputs record counts, hence, duplicate can't be possible. Thanks.

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.

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.