Script problem

[Carlaf_93]

Good morning,

i have a problem with my script.

[ag]:
LOAD
AGECCODICE 
[AGECDIVISION]
from (qvd);

[BASE]:
Load

 [Codice_Agente],
[COD_ART],
[DATA] ,
[value]

From 2 (qvd);
join
load
AGECCODICE, 
[AGECDIVISION]
Resident ag;

drop table ag;

I would like to put an if condition on AGECDIVISION about the data field...

It doesn't works because Qlikdoesn't understand that data is in the same table...

Any ideas?

[Anil_Babu_Samineni]

I didn't understand some thing here? Why can't you create another field with in table?

[ag]:
LOAD
AGECCODICE 
[AGECDIVISION]

If(....) as DateField
from (qvd);

[BASE]:
Load

 [Codice_Agente],
[COD_ART],
[DATA] ,
[value]

From 2 (qvd);

If that is not possible during QVD loads you can try this way

[ag]:
LOAD
AGECCODICE 
[AGECDIVISION]
from (qvd);

[BASE]:
Load

 [Codice_Agente],
[COD_ART],
[DATA] ,
[value]

From 2 (qvd);

Final:

NoConcantenate
load
AGECCODICE, 
[AGECDIVISION]
Resident ag;

drop table ag;