Forum Discussion
Join two tables to add multiple rows with details
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?
Hi Anonymous ,
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
2 Replies
Hi Anonymous ,
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