Question 11 Views Arun Kothapalli (Arun.Kothapalli) CPF Board Principle Consultant CPF Board SG View Profile Send Message Arun.Kothapalli Member since 2016 12 posts CPF Board Posted: March 10, 2021 Last activity: March 11, 2021 Posted: 10 Mar 2021 20:55 EST Last activity: 11 Mar 2021 4:18 EST 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 Reply Like (0) Share Share this page Facebook Twitter LinkedIn Email Copy link Copying... Copied!