Forum Discussion
add row based on missing data
I have to two DB's that I am trying to keep the same reports.
here is the dilemma
Table1 and Table 2 have all the same attributes but Table 2 has one that table 1 doesn't.
This breaks the reporting with "fix this" because the attribute is being relied on.
I am able to pull that value from another table "Table3"
So my goal is:
If Attribute name is missing 'meeting' then add a row with Roomname that is missing it.
Then get value from table3 column 1
Table1:
| attributename | roomname | Value |
| inuse | Room4 | 0 |
| inuse | Room2 | 0 |
| inuse | Room1 | 1 |
| Desktop | Room1 | 1 |
| inuse | Room3 | 0 |
Table 2
| attributename | roomname | Value |
| inuse | Room4 | 0 |
| inuse | Room2 | 0 |
| inuse | Room1 | 1 |
| Desktop | Room1 | 1 |
| inuse | Room3 | 0 |
| meeting | Room3 | 0 |
| meeting | Room1 | 1 |
not what I was looking for but it did help get to where I need to resolve the issue.
Thank you.
2 Replies
Hi rtillery2000,
It's hard to add rows. The solution could be creating a calculated table with all the attributes.
Table = DISTINCT ( UNION ( VALUES ( Table1[attributename] ), VALUES ( Table2[attributename] ) ) )Best Regards,
Dale
not what I was looking for but it did help get to where I need to resolve the issue.
Thank you.
