Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

SQL query for empty string data type

tectonics25
6 - Meteoroid

Hi, I am trying to use a SQL query in Input tool, to get a portion of data from a server, and I need to ask for "not empty" values. the column is string, so when I use "is not null" it doesn't work. can someone help me what should I use instead to get not empty values? here is my SQL:

 

SELECT RPPO, RPPDCT, RPOBJ, RPSUB, RPVINV, RPDIVJ, RPLNID, RPPYIN, RPSBL, RPSBLT, RPDOC
FROM JDESTAGE.F0411_LT
where RPDIVJ>=122001
and RPPO is not NULL

 

Thanks!

5 REPLIES 5
DataNath
17 - Castor

How do you get on if you replace the bottom line with this?

 

AND RPPO != ''

 

tectonics25
6 - Meteoroid

I did try this but didn't work out.

DataNath
17 - Castor

@tectonics25 are you getting an error message? Or it’s just leaving empty values in? Can you check what they actually are like are your empties 5 x white space for example? More info would be great cheers.

tectonics25
6 - Meteoroid

Actually that worked! I forgot to put space between the quotation marks. Thank you so much for your help!

DataNath
17 - Castor

No problem @tectonics25! If this sorted the issue, feel free to mark the solution so others with the same problem can easily find it in future! :)