Discussion Board for collaboration on QlikView Scripting.
I have table A and I want to load this in Qlikview with left join or any join
and Table B
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.
Go to Solution.
Please find the attachment...
You can use the mapping function for this instead of join.
Make 2 mapping tables, one for DIV and one for DEPT
Then use these mapping tables when you load tableA to fill in the values for the 2 columns.