Difficulty to aggregate

[#1]

Hi everyone,

I have been working today on an application but didn't succeed in it. I started with an Excel file of purchase. Each line represents a purchase of a product. However, one or many purchases are attached to one purchase bill, that has an ID.

My goal is to have in QV only a line per bill and where I has to add columns containing the products that has been purchased. I assume that a bill can contain only 10 products.

Thank you very much !

[buzzy996]

share ur .qvw else sample data and expected output!

[#3]

[Anonymous · Accepted solution]

You can load your data as is, and on the front end charts use ID as dimension.  Other data - aggregate in expressions, like sum() or count.  If you need to aggregate text values, use concat().

For more specific answers - upload an example of your application.

[#5]

Here is my input and excpected output, I couldn't build a working script yet because I don't know how to figure it out

[Anonymous]

Does the attached work for you?

[#7]

I don't see any file attached

[Anonymous]

Can't help with that...    Ask Forum admins for help.

(I see you have an answer from gwassenaar‌ here Transaction with different products in one line )

[buzzy996]

see this

[#10]

It works for me with your documents, however, could it be a problem not to be able to have distinct columns for products values?