Skip to content
+1-888-319-3663

COMMUNITY FORUM

ODBC Connection – too few parameters

BethZK asked 7 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.  
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]

 
Answers
Best Answer
BethZK answered 7 years ago
I figured this out.

If you would like to submit an answer or comment, please sign in to the eOne portal.