Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Maybe this is best suited for a SQL discussion but here goes.
I want to pull in all rows except for the ones where DOINVSTATUSID is not equal to NULL.
I tried WHERE DOINVSTATUSID <> ';'. ITMSNumber NOT LIKE '_%'; (because I don't want the ones with a character at the front), DOINVSTATUSID IS NOT NULL;
None of them work.
So its correct in SSMS but Qlik is pulling in invalid rows?!
You're probably right Adam... I think there is something else going on here. I'll have to start a new discussion.
No worries, feel free to tag me in it and I will take a look
Hi plz check the attached doc, i hope it will help you
I can't open it.... I have personal edition I believe, even though I'm working for a conglomerate.