evaluate row content

[mambi]

Hello,

i'm connecting qv with mysql db and i have a varchar field like this :

Column:

10+22

3-4

15+10

...

in the load script  or in a chart i want to evaluate each row so i'll get :

Column

32

-1

25

i don't want to use subfield in the load script because it duplicate rows.

the function evaluation returns 0.

any idea how to do it ?

[Anonymous]

Use the Evaluate() function :

Load

Evaluate(Column) as Evaluated ,

*

;

LOAD * INLINE [

    Column

    10+22

    3-4

    15+10

];

[mambi]

i already tried this but when data come from mysql db the result is different (it's return 0)

[Anonymous]

Maybe force it to Text before the Evaluate :

Load

evaluate ((Text(Column)) as Evaluated ,

*

;

LOAD * INLINE [

    Column

    10+22

    3-4

    15+10

];

[mambi]

nothing

[Anonymous]

Works with a basic Inline Load, something must different with your actual data.  Could you share a small qvd with some sample data ?

[mambi]

here's a qvd file

[Anonymous]

With that qvd it works fine like this :

LOAD

  column ,

  Evaluate(column)

FROM

test.qvd

(qvd);

qvw file attached.

[mambi]

it's will drive me crazy !!

your file works fine , but if i copy your script into my own file it's won't work :-(((

[Anonymous]

What if in your script you :

• Load data from your mysql db
• Store into qvd
• Drop table
• Load from the qvd & Evaluate()