Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All
Find below Mother Table format & have create child table as per below
Mother Table
MONTH | AGENCY | CHG_CODE | VDA AMOUNT | BKG_NUM | CON_NUM | VDA NUM |
November-18 | SHAL-CCU | WASH | 9.75 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | SUR | 9.75 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | SOR | 0 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | LAS | 0.05 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | ISPS | 3.25 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | ICOM | -10 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | FRT | 300 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | EQP | 26 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | ECRS | 150 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | DTHC | 117 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
November-18 | SHAL-CCU | DMG | 9.27 | SHLPK18001152 | AMFU3221483 | AGIN1819000129HQ |
Child Table: 1
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |