Data Load with customer function

[jduenyas]

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

[Lee_Matthews]

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