Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vikasmahajan
Honored Contributor III

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

1 Solution

Accepted Solutions
venkatasreekant
Valued Contributor

Re: create table with left join along with multiple dimension

Hi Vikas

Please find the attachment...

2 Replies
venkatasreekant
Valued Contributor

Re: create table with left join along with multiple dimension

Hi Vikas

Please find the attachment...

geert_gelade
Contributor

Re: create table with left join along with multiple dimension

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.

Community Browser