Question

4
Replies
503
Views
ShrutiG6684 Member since 2019 5 posts
Bank of America
Posted: 11 months ago
Last activity: 11 months 2 weeks ago

How to process multiple values in csv files in file listener

We have a requirement where in external team sends csv file and we need to parse each and every row and create case ( basic scenario)
Column are as follows
(these are some example:)

Name|ID|Address|Country|Skills

John|123|123 Lane|US|Java,Pega,SQL

My question - last column has multiple comma separated values. I can parse delimit using "|" the various columns like Name etc and save to DB but how do we handle the last column where we have comma separated values in various rows in DB like:

John|123|123 Lane|US|Java

John|123|123 Lane|US|Pega

etc

Also how do we handle in File Listener service activity in Parse Segment section where I need to read every rows taking "," in account

Low-Code App Development Data Integration
Share this page LinkedIn