Originally posted by: Vikrant264

I want to concat lines in functionl map on input conditions for Eg:

sample input:
:72:/REC/Instruction information
//Of the Record
/TELE/Instruction Information
//Of the Telephone
/TELE/Instruction mation
I am sending this input to the functional map and i want to append the next line to previous line if it starts with 2 slashes

sample output
/REC/Instruction information //Of the Record
/TELE/Instruction Information //Of the Telephone
/TELE/Instruction mation

has anyone encountered this kind of scenario?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: lanapoli

From your post it seems that input records that begin with a single slash (/) and subsequent records that begin with double slash (//) are all part of one record in the output data. Therefore I would create a group in the input type tree such that all the sub-records (rows that begin with //) would be included in the group with it's parent (row that began with /). Then you could pass the entire group to the functional map and prepare the output.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Vikrant264

I am new to WTX , so can you please elaborate how do i create groups of specific data ?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: lanapoli

Post your input type tree, and I will modify it as explained with groups.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: Vikrant264

I got your point ,but my requirement does not allow me to modify the MTT file so is there any way by which i can concat the next line to the previous line in functional map ?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: lanapoli

What requirement do you have that restricts the modification of the type tree? The type tree defines the meta-data for the input files. The creation of groups can enable you to more effectively process the data but should not alter anything.

Regardless, you could ensure your type tree for your output field is not terminated by a new line, and then use a rule in the mapping to state if the record begins with a single slash add a <NL> before the text.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SATH66

we can try something like below
IF(MID(Recordname,1,2)="//",seriestotext())
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

You can also use substitute(seriestotext(input1), termiantor+"//", delimiter + "//")
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender