1 Reply Latest reply: Sep 10, 2014 5:50 PM by Bella Mae RSS

    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 [D:\Project LAC Reconciliation UI\Data\OGIS\LEBANON-NOAL30.txt]
      (fix, codepage is 1252, no eof)
      Where Exists(Key, [Acct-Ln] & '-' &[Tran-Type] );
      DROP Table TEMP;