Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table1:
Load * inline [
Program , Table_Name
LP , A
LP , B
LP , C
LP , D
LP , E
LP , F
];
Table2:
Load * inline [
Program ,Tablename, Status
LP , A , Gold
LP , B , Gold
LP , C , Gold
LP , A , Silver
LP , B , Silver
LP , C , Silver
];
We have to find the tables from table1 which are not present in table 2.
I have used logic for Count Column : count(TOTAL DISTINCT Table_Name) - Count({<Status={"Gold"}>}DISTINCT Tablename) and getting output 3 so we want that 3 missing data in Missing column.
And I tried logic for Missing Column : FirstSortedValue(Tablename,-Aggr((Count({<Status={"Gold"}>}DISTINCT Tablename)) -(count(total DISTINCT Table_Name)),Tablename,Table_Name)) - This logic is not worked.
We Want output below:
Table_Name | Count | Missing Column |
3 | ||
A | 3 | |
B | 3 | |
C | 3 | |
D | 3 | D |
E | 3 | E |
F | 3 | F |
try with
Only({$ <Table_Name-=P({1 <Status={Gold}>} Tablename)>} Table_Name)