Filter multiple fields in data load script

[Betty1]

I am trying to filter my data connection on two separate fields using the data load editor, but it is not working.  I don't get an error... it just doesn't load anything.  I will be combining several tables, but this is the first one.  This is what I have.  I appreciate any help.

LIB CONNECT TO [CEFMSCY];

[AP_TRANS_REG]:
SQL SELECT "SOURCE_FOA",
"OBLI_NO",
"APPROP_SYMBOL",
"GL_ACCT_NUM",
"AMSCO_CODE",
"TRANS_AMOUNT",
"DELIVERY_ORDER_NO",
"EFFECT_DATE",
"DB_CR_IND",
"SOURCE_NAME"
FROM "CEFMSCY"."S0CIA123"."AP_TRANS_REG"
WHERE Match(GL_ACCT_NUM, '211000.3500','211000.3500','211000.1300','101000.5100','211000.1200','211000.1400','900000.3300','900000.3400','900000.3500','900000.3600) AND Match(DB_CR_IND,'C');

[Vegar]

My guess is that your match() function is causing you trouble. When using SQL select you need tonstick with SQL syntax. An workaround is to put the match() conditions in a preceding load like this.

[AP_TRANS_REG]:

LOAD *

WHERE

Match(GL_ACCT_NUM, '211000.3500','211000.3500','211000.1300','101000.5100','211000.1200','211000.1400','900000.3300','900000.3400','900000.3500','900000.3600) AND Match(DB_CR_IND,'C');

SQL SELECT "SOURCE_FOA",
"OBLI_NO",
"APPROP_SYMBOL",
"GL_ACCT_NUM",
"AMSCO_CODE",
"TRANS_AMOUNT",
"DELIVERY_ORDER_NO",
"EFFECT_DATE",
"DB_CR_IND",
"SOURCE_NAME"
FROM "CEFMSCY"."S0CIA123"."AP_TRANS_REG"
;