Forum Discussion
Help Require to compare two Tables
I have two tables as below.
Table AC ( Source Table )
Table WB
Table AC is main. Compare AC with WB.
Here ,
Table WB. A12615 in country 1 not maching in Table AC Country1 - Show in result "X" and highlight.
Table WB. A12616 in country 3 not maching in Table AC Country 3 - show in result "X" and highlight.
Table AC A12618 in country 2 is not matching Table WB country 2 - Show in result "0" and highlight.
Code A12621 is not at all available in Table WB - Show in result "X" and highlight.
Country4 is completely matching in two tables, so it is not required to show in result.
Required result:-
Im not much familiar this platform. Step by step instructions required.
Thank you.
5 Replies
- ryan_mayuSuper User
- siroopm2020Helper I
Can i make a slicer to view "X" or "Empty" ?
- ryan_mayuSuper User
then don't do the pivot in PQ and create a matrix view . pls see the attachment below
- siroopm2020Helper I
Thanks alot. This is working.
- ryan_mayuSuper User
you are welcome