This content has been marked as final.
Show 5 replies
-
Re: HOW TO CONCAT FIELDS?
Shraddha Gajare Dec 2, 2016 12:31 AM (in response to pradnya nemade)For Products Brought
Concat(Distinct [Product Name],',')
-
Re: HOW TO CONCAT FIELDS?
pradnya nemade Dec 2, 2016 7:10 AM (in response to Shraddha Gajare )Thnx for reply.. but it want solution for products which are not bought..
-
-
Re: HOW TO CONCAT FIELDS?
Vegar Lie Arntsen Dec 2, 2016 12:34 AM (in response to pradnya nemade)Take a look at the concat() function.
-
Re: HOW TO CONCAT FIELDS?
pradnya nemade Dec 6, 2016 1:34 AM (in response to Vegar Lie Arntsen )hi,
can you please help me for syntax..
-
-
Re: HOW TO CONCAT FIELDS?
Dhanashri Dindore Dec 8, 2016 7:03 AM (in response to pradnya nemade)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;