Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am loading data from a SP List and one of the fields is Money formatted on the source.
when imported to QlikView I get the data to look like:
Revenue On the Source
float;#200.00000000 $200.00
float;#75.000000000 $75.00
float;#5000.0000000 $5000.00
not sure why I am getting the"float;#" before the nr
I tried to format the field in the in the script as Num() but didn't help.
Anybody has experienced any simillar issue.
Thxs for your help.
Alec
Hi Alec,
Not sure why you're getting the "float;#" part, but you can use:
Replace(Revenue, 'float;#','') as Revenue
Hi Alec,
Not sure why you're getting the "float;#" part, but you can use:
Replace(Revenue, 'float;#','') as Revenue
Hi
Try like this
=Num(Replace('float;#200.00000000','float;#',''),'$#,##0.00') gives $200.00
so in load try like this
Load *,Num(Replace(Revenue,'float;#',''),'$#,##0.00') as Revenue from tablename;
Hope it helps