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,

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

20200518 - ColumnsContainingValue v2.yxmd