topic If statement in load with 2 data sources in QlikView https://community.qlik.com/t5/QlikView/If-statement-in-load-with-2-data-sources/m-p/832270#M992215 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am attempting to move some work that is currently being done offline in Excel before we load into Qlikview to be accomplished in the load script.&nbsp; Today, we utilize several if and vlookup functions in excel to transform data which has become cumbersome.&nbsp; For example:</P><P></P><P>=if(cellA2 = 123, cellB2, vlookup(c2,TABLE,2,false))</P><P></P><P>Does anyone have suggestions as to how I could accomplish that same outcome utilizing the load script?</P></BODY></HTML> Wed, 08 Jul 2015 13:02:52 GMT 2015-07-08T13:02:52Z If statement in load with 2 data sources https://community.qlik.com/t5/QlikView/If-statement-in-load-with-2-data-sources/m-p/832270#M992215 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am attempting to move some work that is currently being done offline in Excel before we load into Qlikview to be accomplished in the load script.&nbsp; Today, we utilize several if and vlookup functions in excel to transform data which has become cumbersome.&nbsp; For example:</P><P></P><P>=if(cellA2 = 123, cellB2, vlookup(c2,TABLE,2,false))</P><P></P><P>Does anyone have suggestions as to how I could accomplish that same outcome utilizing the load script?</P></BODY></HTML> Wed, 08 Jul 2015 13:02:52 GMT https://community.qlik.com/t5/QlikView/If-statement-in-load-with-2-data-sources/m-p/832270#M992215 2015-07-08T13:02:52Z Re: If statement in load with 2 data sources https://community.qlik.com/t5/QlikView/If-statement-in-load-with-2-data-sources/m-p/832271#M992216 <HTML><HEAD></HEAD><BODY><P>You should be able to use a Mapping load with ApplyMap to accomplish what you are trying to do here.</P><P></P><P><A href="http://www.learnqlickview.com/a-qlikview-tutorial-mapping-load-in-qlikview/" title="http://www.learnqlickview.com/a-qlikview-tutorial-mapping-load-in-qlikview/">Mapping Load in Qlikview: A Qlikview Tutorial « Learn Qlikview</A></P></BODY></HTML> Wed, 08 Jul 2015 14:29:55 GMT https://community.qlik.com/t5/QlikView/If-statement-in-load-with-2-data-sources/m-p/832271#M992216 sunny_talwar 2015-07-08T14:29:55Z Re: If statement in load with 2 data sources https://community.qlik.com/t5/QlikView/If-statement-in-load-with-2-data-sources/m-p/832272#M992217 <HTML><HEAD></HEAD><BODY><P>can you provide that excel?</P></BODY></HTML> Wed, 08 Jul 2015 14:46:54 GMT https://community.qlik.com/t5/QlikView/If-statement-in-load-with-2-data-sources/m-p/832272#M992217 2015-07-08T14:46:54Z