How to use the Distinct Column in Datatable as a filter and get each row that match and store it to another Datatable

Help
1

Hello!

I am trying to use the values I got from distinct select and use it as a query parameter. Here is the sample Datatable:

image

I need to separate the items per date of purchase but the date of purchase is unknown. I try to use filter with the date I retrieved from distinct but I am having trouble. Any help is appreciated.

2

Hi @wonderingnoname

What exactly is the issue you are facing here?

3

@wonderingnoname,

Could you please go through below link?

Regards,
Pankaj

4

Hi! I already used the distinct results. I am now having issue with using the result as parameter to filter the original table.

I want to use the dates as filter on the datatable to create datatable for each distinct dates. This is my sample workflow. Filter.xaml (9.2 KB)

5

This is okay now. I converted the datatable to Array and then filtered it using the Array item.
Thanks!

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.