Search many columns for one value

[cassidiecargill]

hi alteryx community!

i have a massive database with months of a document that has over 100 columns of data.

if i am looking for one specific value, but it could be in many different rows, how can i search the entire document (or multiple columns) for this one value?

ex: searching for an order number (red box in snapshot) in our transportation/freight spend data; but the different transportation providers can transmit the data into multiple columns (mawbnumber, packagenumber,BOL number, or many different reference columns not seen in the snapshot)  that is consolidated by our freight payment provider. 

thanks!

[Jonathan-Sherman]

Hi @cassidiecargill,

Is this what you're trying to achieve? I'm searching for rows where one of my columns equals B

Output:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Jonathan-Sherman · Accepted solution]

Hi @cassidiecargill,

Or perhaps you're looking to return all columns where B (or the value you're looking for) exists in at least one column in that row:

If this solves your issue please mark the answer as correct, if not let me know! I've attached an updated workflow for you to download if needed.

Regards,

Jonathan

[cassidiecargill]

Jonathan - Thank you very much. This works wonderfully. 

[mrbillyjackson]

This thread just made my life a lot easier. Thanks!!!