create table with left join along with multiple dimension

[vikasmahajan]

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

[Anonymous · Accepted solution]

Hi Vikas

Please find the attachment...

[geert_gelade]

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.