topic Re: Data Model / Scripting Question in QlikView https://community.qlik.com/t5/QlikView/Data-Model-Scripting-Question/m-p/756037#M269213 <HTML><HEAD></HEAD><BODY><P>Use ApplyMap in this situation, you can find easy examples on Help on line</P></BODY></HTML> Fri, 23 Jan 2015 13:08:05 GMT alexandros17 2015-01-23T13:08:05Z Data Model / Scripting Question https://community.qlik.com/t5/QlikView/Data-Model-Scripting-Question/m-p/756036#M269212 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: calibri, verdana, arial, sans-serif;">Hi all:</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">I have a question about how to create the optimal data model for the following situation</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">I have 3&nbsp; tables (A,B,C) that contain various columns.&nbsp;&nbsp; "A.ColA" , "B.ColB" and "C.ColC" are a lookup value codes. All lookup value codes and their descriptions are stored in a fourth table called "Lookups" and has the following columns </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><SPAN style="font-size: 12pt;">"Lookups.TableName" (values are A, B, C)&nbsp; ; </SPAN><SPAN style="font-size: 13.3333330154419px;"><SPAN style="font-size: 12pt;">"Lookups.ColName" (values are ColA, ColB, ColC) ; </SPAN><SPAN style="font-size: 12pt;">"Lookups.Desc" (values are ColADesc, ColBDec, ColCDesc)</SPAN></SPAN></SPAN></P><P></P><P>How can I load these tables to link the lookup value codes to the appropriate lookup code description?&nbsp; </P><P>Is generic load the right approach ?&nbsp; Any assistance would be appreciated.</P><P></P><P>Thanks</P><P>JT</P></BODY></HTML> Fri, 23 Jan 2015 13:06:10 GMT https://community.qlik.com/t5/QlikView/Data-Model-Scripting-Question/m-p/756036#M269212 2015-01-23T13:06:10Z Re: Data Model / Scripting Question https://community.qlik.com/t5/QlikView/Data-Model-Scripting-Question/m-p/756037#M269213 <HTML><HEAD></HEAD><BODY><P>Use ApplyMap in this situation, you can find easy examples on Help on line</P></BODY></HTML> Fri, 23 Jan 2015 13:08:05 GMT https://community.qlik.com/t5/QlikView/Data-Model-Scripting-Question/m-p/756037#M269213 alexandros17 2015-01-23T13:08:05Z