topic Star is Question in QlikView https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148820#M27043 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'd like to link two tables and I have to use Star is:</P><P>Star is %;<BR /><BR />Group:<BR />LOAD * INLINE [<BR /> %_Key, Group, City<BR /> X1%, Group_1, Berlin<BR /> X2%, Group_2, Moscow<BR /> X3%, Group_3, Milan<BR /> X44%, Group_43, London<BR />];<BR /><BR /><BR />Contacts:<BR />LOAD * INLINE [<BR /> %_Key, Name<BR /> X1223, Client_1<BR /> X2231, Client_2<BR /> X1211, Client_3<BR /> X3315, Client_4<BR /> X2134, Client_5<BR /> X4422, Client_6<BR />];</P><P>Unfortunately this isn't working!</P><P></P><P>Is it possible to set a range, e.g. X21% to X31% = Boston?</P><P></P><P>Anyone an idea? Thanks in advance.</P><P></P></BODY></HTML> Wed, 08 Jul 2009 22:51:07 GMT 2009-07-08T22:51:07Z Star is Question https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148820#M27043 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'd like to link two tables and I have to use Star is:</P><P>Star is %;<BR /><BR />Group:<BR />LOAD * INLINE [<BR /> %_Key, Group, City<BR /> X1%, Group_1, Berlin<BR /> X2%, Group_2, Moscow<BR /> X3%, Group_3, Milan<BR /> X44%, Group_43, London<BR />];<BR /><BR /><BR />Contacts:<BR />LOAD * INLINE [<BR /> %_Key, Name<BR /> X1223, Client_1<BR /> X2231, Client_2<BR /> X1211, Client_3<BR /> X3315, Client_4<BR /> X2134, Client_5<BR /> X4422, Client_6<BR />];</P><P>Unfortunately this isn't working!</P><P></P><P>Is it possible to set a range, e.g. X21% to X31% = Boston?</P><P></P><P>Anyone an idea? Thanks in advance.</P><P></P></BODY></HTML> Wed, 08 Jul 2009 22:51:07 GMT https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148820#M27043 2009-07-08T22:51:07Z Star is Question https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148821#M27044 <HTML><HEAD></HEAD><BODY><P>Hi Elzo,</P><P>See attached and comments in the script.</P><P>Regards,</P><P>Gordon</P></BODY></HTML> Thu, 09 Jul 2009 00:21:18 GMT https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148821#M27044 2009-07-09T00:21:18Z Star is Question https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148822#M27045 <HTML><HEAD></HEAD><BODY><P>so there's no way to get it working with star is * ?</P><P>My source is an excel file. Would i be possible to fill up the missing values as an alternative way?</P></BODY></HTML> Thu, 09 Jul 2009 14:10:38 GMT https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148822#M27045 2009-07-09T14:10:38Z Star is Question https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148823#M27046 <HTML><HEAD></HEAD><BODY><P>Is it possible to left join with a key-field that contains *?</P><P></P></BODY></HTML> Thu, 09 Jul 2009 16:33:22 GMT https://community.qlik.com/t5/QlikView/Star-is-Question/m-p/148823#M27046 2009-07-09T16:33:22Z