Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to write a sql select statement to return a match from 3 different columns.
Normally I would use something along these lines to pull from one column and if blank/null then pull from another.
Do I need to use a case statement? If statements? Not sure exactly if Qliksense supports all SQL queries/functions.
Here is my query for what I currently have. I need to pull the existing information from the source_from column first then from the source_name column 2nd if the source_from column is blank/null and then finally MI_loc if both source_from and source_name are blank/null.
VALUE (SUS.SOURCE_FROM || ' - ' ||
SUS.SOURCE_NAME,
SUH.MI_LOC) as SOURCE_OF_MATRL
Many Thanks
I want to share my entire script with you. Once I plugged it in and ran it I got an error, but when I removed to debug it ran just fine.
See my script and you will get a better picture of where I am trying to pull it from