Getting empty space for null record in Hdfs text file

[varadharaj]

When loading from sql server to hdfs with text file format noticed that if the column is null it is writing as ''(empty space) for string datatype, and for integer date type it is writing as null.

Attunity Replicate Version : 6.5.0.481

Is there anyway to write null for string datatype if the attribute is null.

Eg:

|string| |date| |integer|
+----------++-----------------++------------------------+
| |null |null |
| |null |null |
| |null |null |

[Madhavi_Konda]

Hi Varadharaj,

Table Settings->transform->on individual String column->Build an expression like the following
case when $col='' then null else $col end

Thanks,
Madhavi

[varadharaj]

Hi Madhavi,

Below expression will transform source data column from '' to null.

But my requirement is in source it has (null) for string attributes and when loading to hadoop it is '' for string column.

Is there any to apply globally for string column for all tables instead of column level mapping.

[Madhavi_Konda · Accepted solution]

Hi Varadharaj,
Please open a support ticket in the support portal for this requirement.
https://attunitysupport.qlik.com/login?ec=302&startURL=%2Fs%2F.

Thanks,
Madhavi

[Attunity_user]

Hi Madhavi,

There is a global transformations available in the designer that you can add that logic for string or numeric data types or at the table level.

Thanks,

AU