Partial Relaod field not working , Load script work fine.

[paulyeo11]

Hi All

I have below 3 section of load script , my objective is to create below field :-
[rEVENUE_T]
[rEVENUE_P]
It return null , which is wrong.

(A) Load Company A GL Data

GL_TABLE:
LOAD
'TDS' as SOURCE,
@124:129T as [Reporting Code],
If(@124:129T>=1 and @124:129T<=1,'YES') as [rEVENUE_L1],
date#(MakeDate(@53:57T,if(@50:52T=13,12,@50:52T) ,1),'DD/MM/YYYY')as date,
if(@102:103T = '-',@86:101T*-1,@86:101T)*-1 as [Amount]
FROM C:\Users\Pauly\Dropbox\5 QV_Final\QV_RAW\FS_TDS.TXT (ansi, fix, no labels, header is 0, record is line);

(B) Load Company B GL Data

Concatenate
LOAD
'PMC' as SOURCE,
[GL Code] as GL_CODE_,
[GL Code],
If([GL Code]>=5000001 and [GL Code]<=5999999,'rEVENUE_L') as [rEVENUE_L],
Date(Date#([Posting Date],'M/D/YYYY'), 'DD/MM/YYYY') as [date],
[Debit(LC)]
FROM
[C:\Users\pauly\Dropbox\5 QV_Final\QV_RAW\GL_PMC_2020.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

(C) PArtial load to Create Field rEVENUE_T and rEVENUE_P

TABLE_P:
left keep (GL_TABLE)
load GL_CODE_,[Reporting Code],
If([Reporting Code]>=1 and [Reporting Code]<=1,'rEVENUE_T') as [rEVENUE_T],
If([GL_CODE_]>=5000001 and [GL_CODE_]<=5999999,'rEVENUE_P') as [rEVENUE_P]
resident GL_TABLE;

Hopw some one can advise me where i go wrong ?

Paul Yeo

[paulyeo11]

Hi All

Enclosed my QVW

[paulyeo11]

Hi All

Today i try only load company A GL raw data as below , it is working fine :-

GL_TABLE:
LOAD
'PMC' as SOURCE,
[GL Code] as GL_CODE_,
[GL Code],
If([GL Code]>=5000001 and [GL Code]<=5999999,'YES') as [rEVENUE_L],
Date(Date#([Posting Date],'M/D/YYYY'), 'DD/MM/YYYY') as [date],
[Debit(LC)]
FROM
[C:\Users\pauly\Dropbox\5 QV_Final\QV_RAW\GL_PMC_2020.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

TABLE_P:
left keep (GL_TABLE)
load GL_CODE_,
If([GL_CODE_]>=5000001 and [GL_CODE_]<=5999999,'YES') as [rEVENUE_P]
resident GL_TABLE;

Why i am not allow to load to company GL raw sata and make the partial reload okay ? What is the reason that cause the partial reload stop working ? Hope some one can advise me.

Paul

[paulyeo11]

Hi All

I also try to load only load Company B GL Raw data , and the Partial reload field working fine :-

GL_TABLE:
LOAD
'TDS' as SOURCE,
@124:129T as [Reporting Code],
If(@124:129T>=1 and @124:129T<=1,'YES') as [rEVENUE_L1],
date#(MakeDate(@53:57T,if(@50:52T=13,12,@50:52T) ,1),'DD/MM/YYYY')as date,
if(@102:103T = '-',@86:101T*-1,@86:101T)*-1 as [Amount]
FROM C:\Users\Pauly\Dropbox\5 QV_Final\QV_RAW\FS_TDS_.TXT (ansi, fix, no labels, header is 0, record is line);

TABLE_P:
left keep (GL_TABLE)
load [Reporting Code],
If([Reporting Code]>=1 and [Reporting Code]<=1,'YES') as [rEVENUE_T]
resident GL_TABLE;

What is the work around to allow me load 2 company data ?

Paul