when function

[#1]

SORRY for double posting! I had a "server-timeout" and pushed the refresh button obviously far too often!

Dear all,

when using the following code in the script, an error (table cannot be found left join (Data1)...) occurs.

Data1:
when Value1 = 'OK'
Load
 ID,
 Value1
Resident OriginalData1;

left join (Data1)
LOAD
 ID,
 CountID,
 Month,
 Weekday,
 Start,
 End,
 Date
RESIDENT OriginalData2;

Is the placement of the when function correct?

Thankx for helping!

Nico

[#2]

Hi,

it should look like this:

Data1:
Load
ID,
Value1
Resident OriginalData1

when Value1 = 'OK'
;

Good luck!

Rainer

[#3]

good idea, but it is not working.

a script error occurs:

Error in Syntax
Data1:
Load
ID,
Value1
Resident OriginalData1
When Value1 = 'OK'

The "when" does not turn into blue color in the script?!

Maybe the where function is a better choice?

[#4 · Accepted solution]

I used a "WHERE"-clause in my script.

<blockquote><pre>Data1:
Load
 ID,
 Value1
Resident OriginalData1
where Value 1 = 'OK';

left join (Data1)
LOAD
 ID,
 CountID,
 Month,
 Weekday,
 Start,
 End,
 Date
RESIDENT OriginalData2;