Forum Discussion
Gozde
Helper I
Helper IAdd rows to table according to grouping in different table
Hi, I would like to add rows to one table ( or combine two tables) according to group number from another table. These are what I have: Table 1 Name Part A x1 B y1 B x1 ...
GozdeHelper I
Helper IYes, definetely!
| Table 1 | |
| Name | Part |
| A | x1 |
| A | z1 |
| B | y1 |
| B | x1 |
| C | k1 |
| Table 2 | |
| Group | Part |
| 1 | x1 |
| 1 | x2 |
| 2 | y1 |
| 2 | y2 |
This is my expectation:
| Final Table | ||
| Name | Part | Group |
| A | x1 | 1 |
| A | x2 | 1 |
| B | y1 | 2 |
| B | y2 | 2 |
| B | x1 | 1 |
| B | x2 | 1 |
| A | z1 | |
| C | k1 |
Thank you again!
Regards,
Gozde
Zubair_Muhammad
Community Champion
Community Champion
Try with this code
New Table =
VAR Mytable1 =
ADDCOLUMNS (
Table1,
"My Group", CALCULATE ( FIRSTNONBLANK ( Table2[Group], 1 ) )
)
VAR JoinTables =
ADDCOLUMNS (
GENERATEALL (
SELECTCOLUMNS (
mytable1,
"Name", [Name],
"My Group", [My Group],
"My Part", [Part]
),
FILTER ( Table2, Table2[Group] = [My Group] )
),
"Final Part", IF ( ISBLANK ( [Part] ), [My Part], [Part] )
)
RETURN
SELECTCOLUMNS (
JoinTables,
"Name", [Name],
"Group", [Group],
"Part", [Final Part]
)- Zubair_Muhammad
- Gozde
Yes, changing generate to generateall solve the issue!
Thank you very much,
Gozde
- Zubair_Muhammad
Actually in addition to GenerateAll there was a subtle issue with Parts Column as well :smileytongue: