Modify imported data

[Carlaf_93]

Good morning,

i would like to change a value in a data when i'm importing them.

For example:

load * inline [

CLASS, VALUE,

A, 100,

B, 200,

C,209,

C,-120];

Ii would like to have --> when CLASS=C and value>0 give me NEW CLASS D,

when CLASS=C and value<0 give me NEW CLASS E

and drop the C class

how can i do it?

[Taoufiq_Zarra]

Like ?

Data:

load if(CLASS='C' and VALUE>0,'D',if(CLASS='C' and VALUE<=0,'E',CLASS)) as CLASS, VALUE inline [

CLASS, VALUE

A, 100

B, 200

C,209

C,-120];

output :

[Carlaf_93]

LOAD
if(A='22720010' and B<0,'DDD',IF(A='22720010' and B>0, 'CC',A)) AS CLASS,
    [A] AS  CLASS,
    [B] AS  VALUE,
    [C] AS  YEAR
   
FROM excel

What's wrong?

[Taoufiq_Zarra · Accepted solution]

LOAD
if(A='22720010' and B<0,'DDD',IF(A='22720010' and B>0, 'CC',A)) AS CLASS,
    [A] AS  CLASS,
    [B] AS  VALUE,
    [C] AS  YEAR
   
FROM excel

two field same name !

maye be :

if(A='22720010' and B<0,'DDD',IF(A='22720010' and B>0, 'CC',A)) AS CLASS,
[B] AS VALUE,
[C] AS YEAR

from ...

[Carlaf_93]

Thank you!! Great help!