How to get customer list who bought both the item

[loganathan]

Hi all,

Need a help on below.

Sample date:

from the above i wanted to create a table with the details as whoever bought both apple and oranges. expecting the table as a result.

any inputs please

TIA

[rubenmarin]

Hi, you can just do a couple of inner join with both conditions:

InitialTable:
LOAD sno, name...
;

Inner Join LOAD name Resident InitialTable where item='apple';
Inner Join LOAD name Resident InitialTable where item='orange';

 Add the necessary fields to create the expected table.

[MarcoWedel]

Concat({$<name=p({$<item={'apple'}>})*p({$<item={'orange'}>})>} item,' and ')