Dayalan Punniyamoorthy Blog

Tuesday, August 8, 2017

What does EPM Automate Utility offer - Part 4

In this series lets see how to read a file and strip a particular value from a column of a CSV file and use that value in the EPM automate script.

Requirement:

Every month the pay details are extracted from the source system and the data file is loaded into the PBCS, to get this automated the file name should be named as MMM-YY (Pay month and year format).

Let us explore how this is achieved using the EPM  automate.



Declaration Part of the Script:
Preparing the File for reading the contents 


Extracting the Pay month & year



Renaming the file and uploading to PBCS



Hope this helps.


No comments:

Post a Comment