Conditional sorting of transactional records

[vpawate]

Any bright ideas to write an expression to filter records  of "Customers who have ONLY been to France & Mexico"  in the below table ?

Customers	Country
Bob	Mexico
Bob	France
Bob	Japan
John	US
Ken	France
Ken	Japan
Cathy	US
Cathy	France
Cathy	Mexico
Cathy	Japan
Mark	Mexico
Mark	US

[krishnamohan_corp9 · Accepted solution]

Hi Vinay,

Add the source table to the project, create a view on top of that source table.

1. add the columns to output schema.

2. Filter out the condition which you were looking for & save it.

3.  select the view and click view data.

Mark it as correct if the answer is helpful.

Regards

Krishna Mohan

[vpawate · Accepted solution]

I don't think you understood the requirement .

Try and find out all customers who have gone ONLY to France & Mexico.

Keep in mind each customer has gone to multiple countries - but the requirement me to find out who has gone just for the two mentioned above.

[Former Member · Accepted solution]

Hi Vinay

The method above is correct he just used the wrong country to filter

$Country IN ('Mexico','France') would be the expression.

[Former Member]

Hi Vinay

It depends where you want to filter it. You can create a view and apply filter in view or if you want to run a rule you can add filter there as well

[vpawate]

Either option is fine - am looking for an expression which will scan the values of the country for every customer and show only those 2 countries.