Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following code:
SQL SELECT "FIRST_STATUS", "IC_1ST_RD_DT", NAME00, "PROCESS_ID", "SECOND_RD_DT",
"SECOND_STATUS", "WT_OWNER", "YE_DT",
"YE_STATUS", FIRSTNAME AS TESTMANAGER
FROM OPX."RT_PROCESS", OPX.USERINFO, OPX.ACTORINFO
WHERE OPX."RT_PROCESS"."TEST_MANAGER" = OPX.ACTORINFO.NAME
AND OPX.ACTORINFO.ACTORID = OPX.USERINFO.ACTORID;
which pulls the data just fine.
When I change the third line to FIRSTNAME + LASTNAME AS TESTMANAGER
The column headers load, but not the data. Can anyone explain why?
Thanks!
Try with double pipe
SQL SELECT
"FIRST_STATUS","IC_1ST_RD_DT", NAME00, "PROCESS_ID", "SECOND_RD_DT",
"SECOND_STATUS", "WT_OWNER", "YE_DT",
"YE_STATUS",
FIRSTNAME || LASTNAME AS TESTMANAGER
FROM OPX."RT_PROCESS", OPX.USERINFO, OPX.ACTORINFO
WHERE OPX."RT_PROCESS"."TEST_MANAGER" = OPX.ACTORINFO.NAME
AND OPX.ACTORINFO.ACTORID = OPX.USERINFO.ACTORID;
or
SQL SELECT
"FIRST_STATUS","IC_1ST_RD_DT", NAME00, "PROCESS_ID", "SECOND_RD_DT",
"SECOND_STATUS", "WT_OWNER", "YE_DT",
"YE_STATUS",
Concat(FIRSTNAME, LASTNAME) AS TESTMANAGER
FROM OPX."RT_PROCESS", OPX.USERINFO, OPX.ACTORINFO
WHERE OPX."RT_PROCESS"."TEST_MANAGER" = OPX.ACTORINFO.NAME
AND OPX.ACTORINFO.ACTORID = OPX.USERINFO.ACTORID;
For a space between first and last name
SQL SELECT
"FIRST_STATUS","IC_1ST_RD_DT", NAME00, "PROCESS_ID", "SECOND_RD_DT",
"SECOND_STATUS", "WT_OWNER", "YE_DT",
"YE_STATUS",
FIRSTNAME || ' ' || LASTNAME AS TESTMANAGER
FROM OPX."RT_PROCESS", OPX.USERINFO, OPX.ACTORINFO
WHERE OPX."RT_PROCESS"."TEST_MANAGER" = OPX.ACTORINFO.NAME
AND OPX.ACTORINFO.ACTORID = OPX.USERINFO.ACTORID;
Thank you so much!
Did it work? I am guessing it did.... I would suggest closing this thread by marking correct and helpful responses.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny