Forum Discussion
Combine row based on criteria (Product Package)
Hi everyone, I am currently doing data analysis for my restaurant and got stuck in a process. I have set of data below: Sales Number Menu Category Menu Category Detail Menu Qty Pr...
Ryan_Izzan Not particularly proud of this solution (attached) as it looks a bit clumsy. But it seems to work on this small scale. See if it works for you in-real-life.
- Thank you for your response.
Sorry for late response, i just try it today but kinda stuck in "Group" step. it keeps loading and the size reach 1,7 GB and still increasing.
Its my fault that i didn't mention that the table has 23 column and 20.000+ rows. As you mention before, maybe it works on small scale.
Is there any way to solve this problem, or any better solution from my new information
Regards,Ryan_Izzan Difficult to say what's causing it. 20 thousand rows by 23 columns isn't all that spectacular.
Can you upload or share (Onedrive or similar) a larger and more realistic data set? Not all 20000 rows though but include all columns. Anonymize the data if needed.
Please find my dummy version of my data, hope that it can give another input to the solution
