Data Load with customer function

jduenyas — Tue, 29 May 2012 22:51:54 GMT

Hi All

Is it possible to call a custom function which I have built into the VB Module to evaluate elappsed time between dates into a field at Load time?

Also, is it possible to use the function in an expression?

LOAD

ProjectEngineerID,
EmailReceivedOn,
QuotedOn,
TimeCard(EmailReceivedOn,QuotedOn) AS ElapsedTime;
SQL SELECT *
FROM QDB.dbo.vuPESTATS;

The TimeCard is the cutome function which I have built. (Sample file is attached)

Running the function in the VB Module works OK but no values are returned during the load time.

Thanks

Josh

Re: Data Load with customer function

Lee_Matthews — Tue, 11 Jun 2013 23:44:58 GMT

This is an old post with no reply. For any users searching for an answer to this in future, the answer is Yes. Check out this thread http://community.qlik.com/message/67282#67282