topic pass in QlikView https://community.qlik.com/t5/QlikView/pass/m-p/20022#M3322 <HTML><HEAD></HEAD><BODY><P>Hi team,</P><P></P><P>I am in a need of solution.</P></BODY></HTML> Wed, 14 Feb 2018 06:05:31 GMT Anonymous 2018-02-14T06:05:31Z pass https://community.qlik.com/t5/QlikView/pass/m-p/20022#M3322 <HTML><HEAD></HEAD><BODY><P>Hi team,</P><P></P><P>I am in a need of solution.</P></BODY></HTML> Wed, 14 Feb 2018 06:05:31 GMT https://community.qlik.com/t5/QlikView/pass/m-p/20022#M3322 Anonymous 2018-02-14T06:05:31Z Re: exist function https://community.qlik.com/t5/QlikView/pass/m-p/20023#M3323 <HTML><HEAD></HEAD><BODY><P>I think this is what you need:</P><P></P><P><EM>OracleData:</EM></P><P><EM>Concatenate SQLData:</EM></P><P><EM>LOAD DateOracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS Date,</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; StringOracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS String,</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; PACOracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS PAC,</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; Cost_Oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AS Cost,</EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; Year(DateOracle) &amp; Month(DateOracle)&nbsp; &amp; StringOracle &amp;&nbsp; PACOracle AS&nbsp; Key</EM></P><P><EM>FROM ..\Link.xlsx]</EM></P><P><EM>(ooxml, embedded labels, table is Oracle)</EM></P><P><STRONG><EM>Where not Exists(SQLKey, Year(DateOracle) &amp; Month(DateOracle)&nbsp; &amp; StringOracle &amp;&nbsp; PACOracle);</EM></STRONG></P></BODY></HTML> Wed, 14 Feb 2018 06:13:40 GMT https://community.qlik.com/t5/QlikView/pass/m-p/20023#M3323 jonathandienst 2018-02-14T06:13:40Z