using SQL function in FDM shows NULL results

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While trying to mask SQL columns in Fast Data Maker using SQL functions and you are seeing the Results as NULL

Environment

All supported versions of FDM

Resolution

Make sure you un-check "Keep Nulls" for SQL Functions .   Keeping NULL means that if target column have null values,  keep them as is.