Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Any Error in this Script

Hi Friends,

I created a Temp file and used to load a table data using Where exist funtion. I am getting error that the fields from where exists funtion could not found. Please help

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

TEMP:
Load * Inline
[
Key
01-01
01-02
02-01
02-02
01-03
01-04
01-05
01-07
01-08
02-03
02-04
02-05
02-07
02-08
01-30
01-31
01-32
01-33
01-50
01-65
02-30
02-31
02-32
02-33
02-65
  ];          

Table:
Load *, [@1:3]  as [Rep-Off],
     [@4:6] as [Cur-Cd],
     [@7:8] as Org,
     [@9:10] as [Mgr-Cd],
     [@11:12] as [Maj-Lin],
     [@13:14 ] as [Min-Lin],
     [@15:21] as  [Iss-Comp],
     [@22:23] as   [Prod-Src],
     [@24:25] as  [Tran-Type],
     [@26:27] as [Acct-Ln],
     [@28:30] as [Prod-Off],
     [@31:40] as [Polcy-No],
     [@41:46] as [Cert-No],
     [@47:56] as  [Claim-No],
     [@57:63] as [Acct-Prd],
     [@64:72] as [Plcy-Inc-Dt] ,
     [@73:81] as [Prem-Eff-Dt],
     [@82:90] as [Loc-Edit-Dt],
     [@91:99] as [Accid-Dt],
     [@100:108] as [Prem-Exp-Dt],
     [@109:117] as [Claim-Cre-Dt],
     [@118:118] as [Correct-Cd],
     [@119:128] as [Plcy-Id],
     [@129:129] as [Rsrve-Tp],
     [@130:138] as [Req-No],
     [@139:140] as [Meth-Of-Pay],
     [@141:149] as [Ind-Acct-No],
     [@150:154] as [Catas-No],
     [@155:155]  as [Ho-Rev-Cd],
     [@156:161] as [Prod-No],
     [@162:163] as  [RI-Type],
     [@164:170]  as [RI-Comp],
     [@171:173] as [Cls-Prl],
     [@174:189] as [Vess-Name],
     [@190:197]  as Blank1,
     [@198:201] as  [Cause-Of-Loss],
     [@202:204] as [Inj-Dam],
     [@205:207] as  [Anat-Prop],
     [@208:210] as [Req-Rev-No],
     [@211:214]  as Blank2,
     [@215:220] as [RI-Stat-Id],
     [@221:227] as Blank,
     [@228:230] as [Cntry-Cd] ,
     [@231:247] as [Grp-Curr-Amt],
     [@248:252] as Blank3,
     [@253:259] as [Acqu-Rte-Grp],
     [@260:266]  as [Agy-Comm-Rte-Grp],
     [@267:273] as [Fac-Rte-Grp],
     [@274:274] as [Pay-Tp],
     [@275:276] as [Loc-Br-Anal],
     [@277:281]  as [Lob],
     [@282:284]  as [Loc-Prd-Src],
     [@285:285] as Blank4,
     [@286:291] as [Ins-Stat-Cd1],
     [@292:297] as [Ins-Stat-Cd2],
     [@298:n] as Blank5
    
FROM
(fix, codepage is 1252, no eof)
Where Exists(Key, [Acct-Ln] & '-' &[Tran-Type] );
DROP Table TEMP;


1 Reply
Anonymous
Not applicable
Author

Are these fields in your txt file? Key, [Acct-Ln], [Tran-Type]