I would need to create a filtered query loop in the where for a column's values. I can't find a solution among the documentation. Has anyone ever done a query that filters for a dynamic value taken from the distinct values of a column?
If you are referring to the table column or file column then a mapping/data synchronization can be used and use that in the filter transformation.
Please have a look on the same:
Retrieving data ...