HOW TO CONCAT FIELDS?

For Products Brought

Concat(Distinct [Product Name],',')

Take a look at the concat() function.

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringAggregationFunctions/concat.htm

hi pradya,

Try this:

Table:

LOAD *,

  1 as Flag;

LOAD * INLINE [

    CustomID, Items

    1, S1

    1, S2

    2, S3

    2, S1

    3, S2

    3, S3

];

Temp:

LOAD DISTINCT Items as AllItems

Resident Table;

Left Join(Temp)

LOAD Distinct CustomID

Resident Table;

Join (Table)

LOAD CustomID,

  AllItems as Items

Resident Temp;

FinalTable:

LOAD CustomID,

  Concat(If(Flag = 1, Items), ', ') as [Items Bought],

  Concat(If(Flag <> 1, Items), ', ') as [Items Not Bought]

Resident Table

Group By CustomID;

DROP Tables Temp, Table;