Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

Partial reload script unable to generate Rev

Hi All

(A) Load Script , REV field is working fine :-

Concatenate
LOAD
'PMC' as SOURCE,
[GL Code] as GL_CODE_,
If([GL Code]>=5000001 and [GL Code]<=5000999,'REV') as [REV],
[Credit(LC)]
FROM
[C:\Users\pauly\Dropbox\5 QV_Final\QV_RAW\GL_PMC_2020.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

(B) Partial rload script , REV1 field is not working :-

TABLE_P:
left keep (GL_TABLE)
load [Reporting Code],GL_CODE_,
If([GL_CODE_]>=5000001 and [GL_CODE_]<=5000999,'REV1') as [REV1],
If([Reporting Code]>=100 and [Reporting Code]<=375,'eXP') as [eXP]
resident GL_TABLE;

Can some one advise me where go wrong ?

Pul Yeo

1 Reply
Highlighted
Master
Master

Enclosed my script