Question

1
Replies
137
Views
judsz Member since 2019 6 posts
PEGA
Posted: 1 year ago
Last activity: 11 months 4 weeks ago
Closed

Parsing CSV File

In are application we have two field which one is already populated to match the data that we have in the excel sheet that we will pull information from which is name. The other is the user count which is the data that we need to pull into are application from the excel spreadsheet using the name associated with that user count. Example if the name is Tech in the excel spread sheet and the user count for tech is 30 then are application needs to look for the name tech in are the spread sheet and match it with the name in the application then take the user count in the application and populate the user count in the application with 30. Please contact me if you have an idea about how to go about this.

Here is the process that happens:

1. First we will get an email and attached to it will be the excel csv file. Which in the excel sheet will hold 3 row of data which will be a name, ID, and User count.

2. Out of the 3 rows of data we will only need 2 of the row for the application which are the name and user count.

3. The application needs to be able to open up the excel sheet and find the name in the excel spread sheet and match it with the name in the application and look for the associated user count with that name and populate the application user count with the user count in the spreadsheet every time we are sent an email with the attached spread sheet. There also need to be a condition that states if the user count is null in the excel sheet and the user count is populated then don't populate the user count in the application.

***Moderator Edit-Vidyaranjan: Updated Platform Capability***

Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn