Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Sirs ,
Keys are not working to get desired result . Please help .
Transction_Table1:
LOAD * INLINE [
Pep1, Pep_ID, Con1, Con_ID, Book_ID, Type_Name, Type_id, YEAR, AREA
Ramgy1, R001, Rony, R1, AB1, Chelasa X, CX1, 2018, Sales
Ramgy1, R001, JIBO, R2, AB1, Chelasa X, CX1, 2018, Bank
Ramgy1, R001, tena, R3, AB3, Chelasa X, CX1, 2018, Craf
Ramgy1, R001, Bilo, R4, AB4, BOSO Y, BO1, 2018,
Ramgy1, R001, HUSSY, R5, AB5, BOSO Y, BO1, 2018,
Ramgy2, R002, Rony, R1, AB6, BOSO Y, BO1, 2018, HF
Ramgy2, R002, JIBO, R2, AB7, BRCK, BR01, 2018, Credit
Ramgy2, R002, tena, R3, AB8, BRCK, BR01, 2018, Bonds
Ramgy9, R009, Azura, R01, AB99, BRCK, BR01, 2018, Bonds
];
Transction_Table:
LOAD * ,
Pep_ID &' | '& Con_ID &' | '& Type_id as Key1
Resident Transction_Table1 ;
DROP Table Transction_Table1 ;
Ref_TABLE1:
LOAD * INLINE [
Pep1_Set, Pep1_ID, Con_SET, Con_ID_SET, Type_Name_SET, Type_id_SET, Set_v_SET
Ramgy1, R001, Rony, R1, Chelasa X, CX1, 0.688637994
Ramgy1, R001, JIBO, R2, Chelasa X, CX1, 0.416381848
Ramgy1, R001, tena, R3, Chelasa X, CX1, 0.848939441
Ramgy1, R001, Bilo, R4, BOSO Y, BO1, 0.164606907
Ramgy1, R001, HUSSY, R5, BOSO Y, BO1, 0.925790609
Ramgy2, R002, Rony, R1, BOSO Y, BO1, 0.249511708
Ramgy2, R002, JIBO, R2, BRCK, BR01, 0.275181944
Ramgy2, R002, tena, R3, BRCK, BR01, 0.027021723
Ramgy3, R003, JOE, J01, Hathway, HWYX01, 0.426505072
Ramgy3, R003, JHON, JH01, Hathway, HWYX01, 0.516350849
Ramgy3, R003, TRACY, TRC01, Hathway, HWYX01, 0.486502392
Ramgy6, R006, AMIGO, AMOG01, BRCK, BR01, 0.860334923
];
Ref_TABLE:
LOAD * ,
'Covered' as Policy ,
Pep1_ID &' | '& Con_ID_SET &' | '& Type_id_SET as Key1
Resident Ref_TABLE1 ;
DROP Table Ref_TABLE1 ;
Exp-output
1)
2) Filter with Values Set and Not Set
Thank You Gurus .
Is there any other way ?
However i needed filter/listbox having values covered and not covered
We have three scenario
1) Record only present in Transction_Table should have a Policy field with value as 'Not covered ' .
2) Record only present in Ref_TABLE should have a Policy field with value as 'Covered ' .
3) Record present in both table should have a Policy field with value as 'Covered ' .
How to achieve this in script ? tresesco . Please help .. I do not want to do any changes using calculated dimension (example which was shared by Rajiv )
Thank You in the advance .
Hi Prahlad
Thanks for your feedback. Will it serve your purpose if its done in the load script?
You can put conditional statement on your load of Ref_TABLE as when Transction_Table Pep_ID is NULL then 'Not covered' else 'covered'.
This way you wont have to do any change on dimension level anymore, as the data will come directly from the table.
Regards
Rajiv.
Thanks you Sir , But i did not undertsand how above will help . Can you please share qvw with your solution ?