I have table A and I want to load this in Qlikview with left join or any join
| Item_Code | Dimension Set ID | Lot No_ | Posting Date | Entry_Type | Doc_Num | Location_Code | Inventory_Post_Grp_Code | Dept_Code | Div_Code |
| LC0000223 | 32182 | NULL | 22/07/2009 | 0 | RD/EX/GRN/0910/00011 | TL-RT0001 | TOOLS-LAB | NULL | NULL |
| LC0000223 | 32182 | NULL | 22/07/2009 | 0 | RD/EX/GRN/0910/00011 | TL-RT0001 | TOOLS-LAB | NULL | NULL |
and Table B
| Dimension Set ID | Dimension Code | Dimension Value Code | Dimension Value ID | Name |
| 32182 | BSEG | 1110 | 221 | Formulation |
| 32182 | ALOC | 130 | 369 | R&D Rabale |
| 32182 | DEPT | 2320 | 920 | R&D - FDF - AMD |
| 32182 | DIV | 1120 | 233 | FDF - Common |
I want to update Dimensions in table A Dept_Code and Div_code where Dimension Set ID is common key for this and
base on where condition Dimesion code= 'DIV' I want to update div and dept while loading in Qlikview.
I have attached excel sheet also , Urgent help required.
Vikas
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
