Filter Data-Random value

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.

Developer Tools

Tips and Tricks

Transformation

Fuzzy Match

Database Connection

Accepted answers

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

All comments

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

Will try the process and give you an update.

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703