Question

3
Replies
359
Views
Michael Tan (tanm1)
PEGA
Sr. System Architect
Pegasystems Inc.
JP
tanm1 Member since 2016 39 posts
PEGA
Posted: June 16, 2017
Last activity: November 6, 2018
Posted: 16 Jun 2017 0:27 EDT
Last activity: 6 Nov 2018 20:02 EST
Closed
Solved

Pega Robotics Studio 8: DBNull in LookupTable (from ExportData)

When using ExportData in the Excel Component to load data into a LookupTable, cells which are empty in Excel are loaded as 'DBNull'.

Is there a way to change this default behaviour and make it load string null instead?

With DBNull we are required to check if the field equals DBNull separately from handling its value; slightly troublesome for our table of 80 columns.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Robotic Process Automation
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.