topic How to get customer list who bought both the item in App Development

How to get customer list who bought both the item

loganathan — Tue, 08 Nov 2022 21:11:01 GMT

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

Re: How to get customer list who bought both the item

rubenmarin — Wed, 09 Nov 2022 08:21:05 GMT

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.

Re: How to get customer list who bought both the item

MarcoWedel — Wed, 09 Nov 2022 21:25:11 GMT

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