Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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');
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"
;