Forum Discussion
How to get a column from table2 to table1 ?
Hi Anonymous ,
In both 2017 and 2018 tables, for each RCP ACCOUNT NO, there existing multiple records which share the same CH3 STATUS value, right?
If so, you could create a bridge table which lists all available unique Account.
Dim account = UNION ( VALUES ( '2017 data'[Account] ), EXCEPT ( VALUES ( '2018 data'[Account] ), VALUES ( '2017 data'[Account] ) ) )Create a one to many relationship from Dim account table to 2017 and 2018 data table based on RCP ACCOUONT NO.
Add relative fields into table visual, you could rename each field being displayed in column header.
Best regards,
Yuliana Gu
HI v-yulgu-msft
Please find below the link, you can find the data in the link provided.
https://drive.google.com/file/d/1Q9GnkVJJAmt20djYC8YDBIvxeBEfJr-h/view?usp=sharing
Also, i need to get the output as below where you can ignore recipient code and take only RCP ACCOUNT NO AND CH3 STATUS.
Please do let me know if you need anyother info.
Microsoft EmployeeHi Anonymous ,
In both 2017 and 2018 tables, for each RCP ACCOUNT NO, there existing multiple records which share the same CH3 STATUS value, right?
If so, you could create a bridge table which lists all available unique Account.
Dim account =
UNION (
VALUES ( '2017 data'[Account] ),
EXCEPT ( VALUES ( '2018 data'[Account] ), VALUES ( '2017 data'[Account] ) )
)
Create a one to many relationship from Dim account table to 2017 and 2018 data table based on RCP ACCOUONT NO.
Add relative fields into table visual, you could rename each field being displayed in column header.
Best regards,
Yuliana Gu