Question

2
Replies
502
Views
 Gigih Suryaman (GISURMAN)
PT Asuransi Jiwa Sinarmas MSIG
PEGA Programmer Specialist
PT Asuransi Jiwa Sinarmas MSIG
ID
GISURMAN Member since 2018 4 posts
PT Asuransi Jiwa Sinarmas MSIG
Posted: January 8, 2019
Last activity: March 29, 2019
Posted: 8 Jan 2019 21:54 EST
Last activity: 29 Mar 2019 8:34 EDT
Closed
Solved

Change format from CSV

Hello,

I have a requirement for uploading csv and mapping into PEGA properties. The problem is, some columns in csv don't have the same format with properties that have been made. My question is can I change the format in parse delimited rule? Or should i use another rule?

i.e. in excel: 1/0, in pega property should be: true/false; in excel: 1/2, in pega property should be: 01/02

Thank You

***Edited by Moderator Marissa to update platform capability tags****

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 23 Jan 2019 5:10 EST
Santanu Bhattacherjee (Santanu)
PEGA
Senior Manager - Sales Automation
Pegasystems Inc.
IN

Hi


it is not possible to map in that way. I tried to do the same and ran into an issue. 


Lets see what other has to say.

Accepted Solution

Posted: 2 years ago
Posted: 28 Mar 2019 23:14 EDT
Gigih Suryaman (GISURMAN)
PT Asuransi Jiwa Sinarmas MSIG
PEGA Programmer Specialist
PT Asuransi Jiwa Sinarmas MSIG
ID

Hi Santanu,


Thank you for your reply. For the case above, i managed to use Data Transform after mapping it to some property.