condition to assign a variable

[#1]

Hi togehter,

how can i set a variable (myVar) during the load process of my csv, if the condition (see below) is true ?
Thank you for any help

************************

MyTable:
LOAD Datum,
if(Datum = '07.01.2011', myVar = 'true', Datum) as DatumCheck,
Impressions

FROM
test1.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

*************************

[#2]

Hi,

For set a variable, you need the command SET or LET.

I recommend creating a field in the table.

You try this.

MyTable:
LOAD Datum,
 if(Datum = '07.01.2011', 1, 0) as FlgTest,
 Impressions
FROM
test1.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[#3]

Hello Tonial,

thank you for your answer. But how can I now send an email alert with QV without a variable?

Thank you!

Yours sincerely,

[#4]

Hi together,

otherwise there is no other way to set variables while loading ? I therefore need a variable
because I want to trigger an email if the records contain old values.

Best regards

[#5 · Accepted solution]

You can try this code after previous code:

Tmp_Table:
LOAD distinct FlgTest as TmpFlgTeste
resident MyTable
where FlgTest = 1;
LET vMyVar = Peek('TmpFlgTeste');

[#6]

Hi Mr. tonial.

thats it ! Thank you very much !

Best Regards