Concatenation in SQL statement causing no data to load?

[#1]

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!

[sunny_talwar]

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;

[sunny_talwar]

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;

[#4]

Thank you so much!

[sunny_talwar]

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