topic Re: SQL query for empty string data type in Alteryx Server Discussions

SQL query for empty string data type

tectonics25 — Tue, 28 Jun 2022 23:14:04 GMT

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!

Re: SQL query for empty string data type

DataNath — Tue, 28 Jun 2022 23:31:15 GMT

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

AND RPPO != ''

Re: SQL query for empty string data type

tectonics25 — Wed, 29 Jun 2022 01:12:11 GMT

I did try this but didn't work out.

Re: SQL query for empty string data type

DataNath — Wed, 29 Jun 2022 07:19:34 GMT

@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.

Re: SQL query for empty string data type

tectonics25 — Wed, 29 Jun 2022 17:33:49 GMT

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

Re: SQL query for empty string data type

DataNath — Wed, 29 Jun 2022 17:47:55 GMT

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! :)