Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Are these fields in your txt file? Key, [Acct-Ln], [Tran-Type]