topic Linking Lookup field in QlikView https://community.qlik.com/t5/QlikView/Linking-Lookup-field/m-p/1193919#M385430 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an existing Data model with customer name and customer id tables.. Now i have got a new excel to link with it. This excel has some columns.</P><P>Major ones are:</P><P>Customer ID, Customer Name and Look Up .</P><P></P><P>Not all Customer Names have a Customer ID. So i want to link this table with my data model using the lookup field like, if there is a Customer ID then through Customer ID and if there isn't a Customer ID, then through Customer name.</P><P></P><P>Look Up has two values Customer name and Customer Id depending on the lookup type.</P><P></P><P>Can anyone help me in this?</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 26 Oct 2016 06:07:14 GMT Anonymous 2016-10-26T06:07:14Z Linking Lookup field https://community.qlik.com/t5/QlikView/Linking-Lookup-field/m-p/1193919#M385430 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an existing Data model with customer name and customer id tables.. Now i have got a new excel to link with it. This excel has some columns.</P><P>Major ones are:</P><P>Customer ID, Customer Name and Look Up .</P><P></P><P>Not all Customer Names have a Customer ID. So i want to link this table with my data model using the lookup field like, if there is a Customer ID then through Customer ID and if there isn't a Customer ID, then through Customer name.</P><P></P><P>Look Up has two values Customer name and Customer Id depending on the lookup type.</P><P></P><P>Can anyone help me in this?</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 26 Oct 2016 06:07:14 GMT https://community.qlik.com/t5/QlikView/Linking-Lookup-field/m-p/1193919#M385430 Anonymous 2016-10-26T06:07:14Z