Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Concat({$<name=p({$<item={'apple'}>})*p({$<item={'orange'}>})>} item,' and ')