I have a file in which there is a column that contains comma separated data. Is there a way to have a new row for each comma separated value in Centerprise. I am version 7.6?
Yes, you may make use of delimited parser to accomplish what you are doing. Just pass the comma separated values as input to the Text field in the Delimited Parser object. Map all other fields that you have to ‘Add new member’ node. Configure the parser options as:
• Parse data pattern: Multiple records
• Record delimiter: , (As the values are comma separated)
Preview the output of the delimited parser. You can the map the output to Passthru transformation to flatten it.