Issue with loading data from SSMS

[Mur]

Hello,

I have an application built in Qlik Sense which is already connected to SSMS. There are already tables pulled over from SSMS, and many reports are built using that data. I am adding a new section in the data load editor, and I am trying to pull another table from SSMS and load it into Qlik Sense. However, every time I write my load script, it gives me an error. Interestingly, when I tried loading the same data into an empty application, it worked fine. What could be the problem preventing me from pulling the data into my existing application?

My load script is simple:

Load:

select ID, Rev1, Rev2,Rev3

From ABCTable

Where Year=2024 and Status= 'Active'

Thank you!

[Fabiano_Martino_Intelco]

Hi @Mur 

can you post more information about the error?

Do you receive a specific error message?

Regards

[Mario_De_Felipe]

Probably you have a syntax error. Did you miss the final semicolon?

Load:

select ID, Rev1, Rev2,Rev3

From ABCTable

Where Year=2024 and Status= 'Active' ;

[Pablo007]

Hi @Mur ,

Looks like you are missing single quotes in 2024  

where reads =2024 

Should read ='2024'

[mshann01]

You definitely don't need quotes around the year value.  Even if it was improperly stored as a varchar, SQL Server converts it on the fly and never throws an error for that.

[mshann01]

send us error and the full script and we'll tell you what the issue is

[Mur]

Thank you all... I found the error.