I have a Greenplum database table as an input for my dataset, let's name this as gp_tableA.
From this dataset, I have a Prepare recipe, we name it as compute_gp_tableA_prepared. I only use this recipe to rename some columns and remove unwanted ones.
I notice at the output dataset (gp_tableA_prepared), one of the record, originally have ' ' as value (a single space), converted to null/blank.
in Greenplum Database: record 1 in ColumnA, value ' ' (a single space)
in Dataiku : record 1 in ColumnA, value '' (blank)
is there any tips to retain the ' ' (space) value, as i need this as part of the logic?
Operating system used: Windows 10