ODBC Connection – too few parameters
BethZK asked 9 years ago
I am trying to use an ODBC connection to map GL transactions from a tab delimited file.
I've used a script that we have currently working on another map and re-used it for this new map and for some reason I am getting an error "too few parameters" Here is the script below – the file has 7 columns-but for some reason the system does not seem to pick them up – I get an error that 7 parameters are expected.
I've used a script that we have currently working on another map and re-used it for this new map and for some reason I am getting an error "too few parameters" Here is the script below – the file has 7 columns-but for some reason the system does not seem to pick them up – I get an error that 7 parameters are expected.
SELECT
GP_Company
,Batch_ID
,LEFT(Transaction_Date,2) + '/' + MID(Transaction_Date,3,2) + '/' + RIGHT(Transaction_Date,2) as Trx_Date
,JE_Reference
,Trx_Reference
,Dist_Account
,Dist_Amount
,SWITCH( Dist_Amount>=0, Dist_Amount, TRUE, 0) as Debit_Amt
,SWITCH( Dist_Amount>=0, 0, TRUE, ABS(Dist_Amount) ) as Credit_Amt
FROM [PIPO_ALL.txt]