Pivot table issue

[kkkumar82]

Hi ,

Any ideas on the above in pivot table

[sunny_talwar]

Not sure I understand the issue?

UPDATE: Can you may be elaborate?

[kkkumar82]

Hi Sunny,

the first table is the way data is and the customer is wishing to see it in the second way , and I am trying to do it in Pivot using above etc but couldn't get it.

Can you suggest any thing without any changes in the edit script.

Thanks

Kiran

[tamilarasu]

Try like below,

Temp:
LOAD * INLINE [
    Sno, Prod Family, Product, Category, Qty
    1, Accessories, Mouse, Hardware, 2
    2, Accessories, Keyboard, Hardware, 3
    3, Accessories, Headset, Hardware, 1
    4, Computer, Windows, S/W, 1
    5, Computer, Office, S/W, 1
];

NoConcatenate
Load RowNo() as Sno, *;
Load [Prod Family],
      Concat(Product,', ') as Product,
      Category,
      Sum(Qty) as Qty
Resident Temp Group by [Prod Family],Category ;

DROP Table Temp;

Note: Try to post data instead of picture.

[florentina_doga]

see attach

[kkkumar82]

Hi Nagraj,

Thanks for your suggestion, but is there a way that we can do it from from end , because we customer don't want to miss the details.

Kiran

[sunny_talwar · Accepted solution]

Like this?

[tamilarasu]

Fine. Check the attachment.

[tamilarasu]

Yes. Chr(10) is appropriate in this case.

[sunny_talwar]

Kumar -

Tamil‌ brought up a great point. It becomes very easy for us to provide a sample if the raw data is not provided as an image. He had to type that up which requires a lot of time and effort. You can continue to post the images, but do include raw data in the form which we can use to just copy paste to create a sample application for you.

Best,

Sunny