create table with left join along with multiple dimension

vikasmahajan — Thu, 25 Sep 2014 11:43:44 GMT

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.

Vikas

Re: create table with left join along with multiple dimension

Anonymous — Thu, 25 Sep 2014 12:12:02 GMT

Hi Vikas

Please find the attachment...

geert_gelade — Thu, 25 Sep 2014 12:16:55 GMT

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.