my input data is like to be a
concat employment all columns in single column but shows errorInvalid expression '${str:concat(record:value('/"employement_details.0.CurrentCompany"'),record:value('/"employement_details.0.c2HhPayroll"')(record:value('/"employement_details.0.c2HhPayroll"')))}': com.streamsets.pipeline.api.el.ELEvalException: CTRCMN_0101 - Error parsing expression ${str:concat(record:value('/"employement_details.0.CurrentCompany"'),record:value('/"employement_details.0.c2HhPayroll"')(record:value('/"employement_details.0.c2HhPayroll"')))}: javax.servlet.jsp.el.ELException: Encountered "(", expected one of [".", ">", "gt", "<", "lt", "==", "eq", "<=", "le", ">=", "ge", "!=", "ne", ")", ",", "[", "+", "-", "*", "/", "div", "%", "mod", "and", "&&", "or", "||", "?"]
Best answer by Bikram
@deepikamani007
I believe you are trying to concate two string values and with space separator. Please find below the code snippet for the same , i hope it helps.
Case 1:
String concate code with space separator:
${str:concat(str:concat(record:value('/"employement_details.0.CurrentCompany"'),' '),record:value('/"employement_details.0.c2HhPayroll"'))}
Case 2:String concate code with nospace separator:
${str:concat(record:value('/"employement_details.0.CurrentCompany"'),record:value('/"employement_details.0.c2HhPayroll"'))}
Case 3 : String concatenate without str:concat function :
${record:value('/"employement_details.0.CurrentCompany"')} ${record:value('/"employement_details.0.c2HhPayroll"')} ${record:value('/"employement_details.0.ctc"')}
Thanks & Regards
Bikram_
