Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

concatenation of multiple strings....

Hello,

How can I cancatenate multiple strings, I tried concat but did not work.

example:

CONCAT_WS( ' ',if(RNAS.R_TRAIN_NAME is null or "","",RNAS.R_TRAIN_NAME)," ", if(RNAS.I_POLICY_TYPE is null or "","",RNAS.I_POLICY_TYPE)," ",

      if(RNAS.C_VEHICAL_TYPE is null or "","",RNAS.C_VEHICAL_TYPE),"",if(RNAS.V_DESTINATION_COUNTRY is null or "","",RNAS.V_DESTINATION_COUNTRY)," ",

if(RNAS.B_R_ORIGIN is null or "","",RNAS.B_R_ORIGIN),"-", if(RNAS.B_R_DESTINATION is null or "","",RNAS.B_R_DESTINATION)," ",

if(RNAS.I_DESTINATION is null or "","",RNAS.I_DESTINATION)," ", if(RNAS.M_REQUEST_DETAIL is null or "","",RNAS.M_REQUEST_DETAIL),"",

if(RNAS.C_SERVICE_TYPE is null or "","",RNAS.C_SERVICE_TYPE),"",if(RNAS.TICKET_NO is null or "","",RNAS.TICKET_NO)

      )  AS 'PARTICULARS'

Pls suggest.

2 Replies
Anonymous
Not applicable
Author

Hi,

Try like this:

LOAD ...

     if(len(R_TRAIN_NAME)>0, R_TRAIN_NAME & ' ' ) &

     if(len(I_POLICY_TYPE )>0, I_POLICY_TYPE & ' ' ) &

     ...

     if(len(RNAS)>0, RNAS) as PARTICULARS

FROM ...;

Anonymous
Not applicable
Author

balrajahlawat,

Please close this thread by selecting correct/helpful answer if it was useful for you. Otherwise, let me now and we will keep on solving your issue.

Thanks.