Question

2
Replies
50
Views
ashishb3420 Member since 2018 12 posts
PricewaterhouseCoopers LLP
Posted: April 2, 2019
Last activity: April 11, 2019
Closed

excel file access

Hi All,

I am trying to read date values from two fixed cells from two different tabs of Excel and then perform substring on one of the values if required.

Need to compare these dates only when both are not NULL. One is in YYYYMMDD format and one is in proper MM/DD/YYYY format. It may happen that the second cell may contain only YYYY.

so I need to convert YYYYMMDD into date and then perform comparison with MM/DD/YYYY in case the second cell has MM/DD/YYYY or just compare YYYY from first value with YYYY in case the second cell only has year.

It seems really difficult to do this with Pega. I have spent 4-5 hours on this already but to no avail. It seems C# script is an easy way here. Can someone please show if I can do this using PEGA. I am attaching two sample excel files. The result needs to be written in third tab saying values match/ do not match or value is missing. I have attached 3 simple excel files with 3 cases.

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

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn