Question 56 Views Arun Kothapalli (Arun.Kothapalli) Pegasystems Arun Kothapalli Pegasystems SG View Profile Send Message Arun.Kothapalli Member since 2016 12 posts Pegasystems Posted: March 10, 2021 Last activity: March 11, 2021 Posted: 10 Mar 2021 20:55 EST Last activity: 11 Mar 2021 4:18 EST Closed How to insert default 0 values instead of null using BIX Report I have a scenario where I need to insert and default the values to '0' instead of NULL for numeric columns in DB using BIX extraction rule In DB numeric column is defaulted to 0. But when I run the BIX extract rule, these default column value is replacing 0 and inserting 'NULL'. But requirement is to keep '0' instead of null. Any suggestions on how to achieve this? Note: making DB column ad not null is not a feasible option because it fails the insert a record into table. ***Edited by Moderator: Pooja Gadige to add platform capability tag*** Pega Platform 7.4 Data Integration Like (0) Share Share this page Facebook Twitter LinkedIn Email Copy link Copying... Copied! Moderation Team has archived post, learn more 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.