This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board for collaboration on Qlik Replicate.
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 : 22.214.171.1241
Is there anyway to write null for string datatype if the attribute is null.
|string| |date| |integer|+----------++-----------------++------------------------+| |null |null || |null |null || |null |null |
Hi Varadharaj,Please open a support ticket in the support portal for this requirement.https://attunitysupport.qlik.com/login?ec=302&startURL=%2Fs%2F.
View solution in original post
Table Settings->transform->on individual String column->Build an expression like the followingcase when $col='' then null else $col end
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.
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.