Join two tables to add multiple rows with details

[kgr]

Hi, 

I want to join two tables, one of them contains all postings grouped and summarized into one row:

Product Code	Booking number	Amount
12345	1111111	150
99999	1111112	1000

I want to split it up / ungroup in a way to see all the details behind the transaction:

Product Code	Booking number	Product	User	Amount
12345	1111111	A1	Tom	50
12345	1111111	B2	Carl	100
99999	1111112	C5	Edwin	200
99999	1111112	D3	Adam	400
99999	1111112	F1	Bert	400

How do I do this? I know how to group a table to reduce number of rows. How do I combine it with another table to add some rows.

Not all rows in the first table might have detailed information but it is the master table that I want to keep the value e.g. 150 from. I just want to add the detailed information. 

How do I do this in a smart way? 

[Anonymous · Accepted solution]

Hi @kgr ,

not sure if I understand correctly... but did you try merging tables by the first to columns and bring the details as a separate column?

If you need it at run-time (in the visual) you can create an index column by combining two first rows and create a relationship in the editor...

If this does not answer your question, please give more details. Considering you have tables A & B what is the look of the combined table you are wanting to achieve?

Thanks,

JB

[kgr]

Thank you, a merge was actually what I was looking for. Not so easy to "ungroup" data, easier to summarize and consolidate different lines into one.