Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
varadharaj
Contributor II
Contributor II

Getting empty space for null record in Hdfs text file

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 |

1 Solution

Accepted Solutions
Madhavi_Konda
Support
Support

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

View solution in original post

4 Replies
Madhavi_Konda
Support
Support

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
Contributor II
Contributor II
Author

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
Support
Support

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
Creator
Creator

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