I took a flat file as a source created a connection for that, I'm doing Event Driven file processing.
I want to perform Concatination on two Source file fields, For that i'm selecting Formula even after creating a Temp Field I'm not able to access the Source field name, these are not available in the Field palatte.
Thanks in Advance!
Following is the syntax to concatenate two fields
$temp.msg1 || '-' || $temp.msg2
For example, If msg1 = Hello & msg2=World, the output would be "Hello-World"
Let me know if this helps you