Field Format issue

[alec1982]

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

[Anonymous · Accepted solution]

Hi Alec,

Not sure why you're getting the "float;#" part, but you can use:

Replace(Revenue, 'float;#','') as Revenue

[MayilVahanan]

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