Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

create table with left join along with multiple dimension

I have table A and I want to load this in Qlikview with left join or any join

Item_CodeDimension Set IDLot No_Posting DateEntry_TypeDoc_NumLocation_CodeInventory_Post_Grp_CodeDept_CodeDiv_Code
LC000022332182NULL22/07/20090RD/EX/GRN/0910/00011TL-RT0001TOOLS-LABNULLNULL
LC000022332182NULL22/07/20090RD/EX/GRN/0910/00011TL-RT0001TOOLS-LABNULLNULL

and Table B

Dimension Set IDDimension CodeDimension Value CodeDimension Value IDName
32182BSEG1110221Formulation
32182ALOC130369R&D Rabale
32182DEPT2320920R&D - FDF - AMD
32182DIV1120233FDF - 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.
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi Vikas

Please find the attachment...

View solution in original post

2 Replies
Anonymous
Not applicable

Hi Vikas

Please find the attachment...

geert_gelade
Creator
Creator

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.