topic Re: Getting empty space for null record in Hdfs text file in Qlik Replicate

Getting empty space for null record in Hdfs text file

varadharaj — Thu, 05 Mar 2020 05:44:44 GMT

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:

Re: Getting empty space for null record in Hdfs text file

Madhavi_Konda — Wed, 11 Mar 2020 14:35:58 GMT

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

Re: Getting empty space for null record in Hdfs text file

varadharaj — Wed, 11 Mar 2020 15:09:07 GMT

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.

Re: Getting empty space for null record in Hdfs text file

Madhavi_Konda — Fri, 13 Mar 2020 21:37:49 GMT

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

Re: Getting empty space for null record in Hdfs text file

Attunity_user — Sat, 14 Mar 2020 22:50:26 GMT

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,