Filter - Records

[suby]

Hi All,

I'm looking for a solution on filtering records attached the sample WF.

[IraWatt · Accepted solution]

Hey @suby,

Interesting problem, here is one way to do this:

First i split out each country and find the Prod's which contain values which are not England or India. Then I join them onto the original data set taking the products which did not match. 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[binuacs · Accepted solution]

@suby Similar to @IraWatt method 

[suby]

Thanks for the solutions

Is there a another way of doing this and assuming that i don't have any column to join is there way to achieve this.

[grazitti_sapna · Accepted solution]

@suby , Here is another solution without using join. Let me know if it works for you and accept my solution.

Thanks!!

[suby]

Thanks Sapna and it works Much appreciated.