Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Qlik Sense Load Error

Hi,

 

I get the following error message

Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 4294960590, ErrorMsg: [Teradata][ODBC Teradata Driver][Teradata Database](-6706)The string contains an untranslatable character.

I have the following variable set up which is causing the problem:

Let vDateEnd = num(year(today()-1))&'-'&num(month(today()-1),'00')&'-'&num(day(today()-1),'00');

Load

SQL

where t.start_txn_date between '$(vDateStart)' and '$(vDateEnd)'

Any idea how I can formulate the vDateEnd variable?

Thanks

Labels (1)
1 Reply
AdiPai
Creator II
Creator II

You could try to declare the variables using the syntax of the source system .. the qlik syntax wont be processed ..