Hi,
While reading a row from source file, i reformat to get only some values from row 1 in source file to new line (row 2) in output.
Like $out.1.email2=$in.0.email2. Thus 1 row can create 2 rows in my output. But this row will have only email2 populated and rest of the columns blank.
Now when i am reading 2nd row from source file, i need to conditionally check if phone number column of 2nd row in output (created due to email2 of row 1 above) is blank. If yes the phone number of row 2 in source must be populated in second row itself rather than creating a new line.
Basically how do i conditionally point to a particular row in output?
Thanks & Regards
Nagaraj K P
Hello Nagaraj K P,
if I understand it correctly what you are trying to achieve is basically to update a record that has already been output by the Reformat component if a certain condition is met. However, I am afraid that from the description of your use case, I am unable to address your question optimally. The fragment of the whole picture still contains many unknowns that might be the key to recommend an ideal solution.
Generally speaking, we do provide conditional statements in CTL as described in our documentation but this approach might not be the right one or at least not the most straight-forward one. Therefore, kindly provide a sample of your source file and a sample of the desired result so that I can provide a more detailed and targeted answer.
Kind regards,