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 |
