topic numeric value from dual field in Resident command in QlikView

numeric value from dual field in Resident command

Anonymous — Wed, 03 Apr 2013 11:02:04 GMT

Hello,

in my script I create some tables with Dual fields. Later in the same script I read the tables with a Resident command and need only numeric values from Dual fields. Which syntax is correct?

For example

Load dualfield

Resident Table

The result is text value but it has to be a numeric value.

Re: numeric value from dual field in Resident command

jonathandienst — Wed, 03 Apr 2013 11:24:44 GMT

This will load the numeric value:

Load Num(dualfield) As numfield

Resident Table

Hope that helps

Jonathan

Re: numeric value from dual field in Resident command

Anonymous — Wed, 03 Apr 2013 12:24:44 GMT

Thanks, it works finely.