Use Condition in Script from previous loaded data

[madmax88]

Hi all,

I Need to use data from a previous loaded data in the same script. Eg.

Table 1:

ID,

IF(SalesP_A='x','Y',

IF(SalesP_B='x','Y')) as SalesAggr

From

XYZ

Table 2:

ID,

IF (SalesAggr = 'Y','great') as SalesAggr_2

From

XYZ

But this doesn't work. Any idea? I heard something about resident table, but also this doesnt work really..

[Vegar]

Try preceding load

Table 1:
Load *,
IF (SalesAggr = 'Y','great') as SalesAggr_2
;
Load
ID,
IF(SalesP_A='x','Y',
IF(SalesP_B='x','Y')) as SalesAggr
From
XYZ
;

-----
Another way is to use resident load

Table 1:
ID,
IF(SalesP_A='x','Y',
IF(SalesP_B='x','Y')) as SalesAggr
From
XYZ;


Table 2:
ID,
IF (SalesAggr = 'Y','great') as SalesAggr_2
RESIDENT
[Table 1]

[pradosh_thakur · Accepted solution]

Table1:

ID,

IF(SalesP_A='x','Y',

IF(SalesP_B='x','Y')) as SalesAggr



From

XYZ



Table 2:

ID,

IF (SalesAggr = 'Y','great') as SalesAggr_2



RESIDENT

Table1;

You need to use th resident load for previously loaded data

[madmax88]

Worked, Thanks both!