Forum Discussion
Grouping rows in table based on one column
Hi! Thanks for the solution.
In the end, I managed to solve it by merging both queries, to create one that is grouped by column "Concept", which was the initial problem.
Super UserAnonymous , Expected output and logic is not clear
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Okey, sorry about that. I mean, I have this real example, which I have been using.
First source, coming from an Excel document, return this 2 rows according to this example:
On the other hand, from the database source, I get these rows:
So, when I match them through another column, they return the table shown in first picture with that 4 rows.
I only need the 1st and 4th row, because that means that price corresponds to its associated concept.
I don't know if this example helped more when analyzing the problem.
Thanks in advance again.