Forum Discussion
Solved
Mark Differences Between 2 Table
Hi There, I have 2 tables, Table 1 and Table 2 and i am trying to mark items that unique/not in each other table We can find and list with EXCEPT but how I want to just to mark it down...
In that case, you can select the relevant columns first from both tables using "SELECTCOLUMNS" function
Then apply the above procedure
i.e.
Calculated Table = VAR firstTable = SELECTCOLUMNS ( Table1, "ID", [ID], "Serial", [Serial], "Name", [Name] ) VAR SecondTable = SELECTCOLUMNS ( Table2, "ID", [ID], "Serial", [Serial], "Name", [Name] ) VAR Common = INTERSECT ( firstTable, SecondTable ) VAR NotCommon = EXCEPT ( DISTINCT ( UNION ( firstTable, SecondTable ) ), Common ) RETURN UNION ( ADDCOLUMNS ( Common, "Unique", "No" ), ADDCOLUMNS ( NotCommon, "Unique", "Yes" ) )
In that case, you can select the relevant columns first from both tables using "SELECTCOLUMNS" function
Then apply the above procedure
i.e.
Calculated Table =
VAR firstTable =
SELECTCOLUMNS ( Table1, "ID", [ID], "Serial", [Serial], "Name", [Name] )
VAR SecondTable =
SELECTCOLUMNS ( Table2, "ID", [ID], "Serial", [Serial], "Name", [Name] )
VAR Common =
INTERSECT ( firstTable, SecondTable )
VAR NotCommon =
EXCEPT ( DISTINCT ( UNION ( firstTable, SecondTable ) ), Common )
RETURN
UNION (
ADDCOLUMNS ( Common, "Unique", "No" ),
ADDCOLUMNS ( NotCommon, "Unique", "Yes" )
)