topic Concatenation in SQL statement causing no data to load? in QlikView

Concatenation in SQL statement causing no data to load?

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Concatenation in SQL statement causing no data to load?

sunny_talwar — Mon, 06 Feb 2017 16:42:04 GMT

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;

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;

Re: Concatenation in SQL statement causing no data to load?

sunny_talwar — Mon, 06 Feb 2017 16:43:27 GMT

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;

Re: Concatenation in SQL statement causing no data to load?

Mon, 06 Feb 2017 17:14:53 GMT

Thank you so much!

Re: Concatenation in SQL statement causing no data to load?

sunny_talwar — Mon, 06 Feb 2017 17:28:02 GMT

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