Filter distinct dataset

Queries and Resources
,
1

Hi, I'm returning a dataset with multiple records for each ID based on a join condition in sql. I need the data as is but would like to bind the dataset to a table but only the distinct records. I thought I could return the dataset and then use a transformer to convert the data. I've looked but can't seem to figure out how.

Thanks

2

Hi @scottcrowley! What do you mean by convert the data? Is the use case filtering a SQL query result for distinct records using a transformer?

3

Can we see an example of your data & a record that you'd like to filter out