There is a custom function defined and it is called in the query transform as function call output.
IF ( $PREV_NAME IS NULL )
$PREV_NAME = $CURR_NAME ;
$PREV_NAME = $PREV_NAME || ',' || $CURR_NAME ;
Return $PREV_NAME ;
Am getting the output always only $Curr_name parameter value, here Prev_name parameter is initialized NULL in work flow stage.
please advise here,why else part is not working and let me know if you need any further information.