Filter Data-Random value

[saiHareesh]

Hi All,

I am trying to filter a particular "data" in Alteryx to check the related content, I would like to give an example 

I have 30 collections/Tables  in a Mongo DB and a random value which exist in those 30 tables say "79f2ty56899oio" i dont no in what column it exists.

How to filter it.

I know the functions of regular filter in Alteryx , where we give the column name and conditions to filter out, my requirement is more like a search option.

Thank you for your suggestions.

[jdunkerley79 · Accepted solution]

Hard to give concrete advise without more details on structure but I would suggest something like.

- Add a RecordID to the data set so you have a unique key

- Transpose the data with the record ID as a key

- Filter the value column for the random value

- Use a summarise or unque tool to get the record ids which have the key

- Join back to original record set on recordid to get rows which have the value

[saiHareesh]

Will try the process and give you an update.

[saiHareesh]

I have used Transpose and filter in the workflow and  luckily i found the record i am looking for.