How to handle null values while Converting .dat file to parquet file

[satpaul]

Hi Team,

I am trying to handle null values using Tmap but getting records whose values are not null.

i have used if else condition but not getting proper output.

Attached screenshot for the same.

[manodwhb]

@satpaul ,can you show the input and output data too?

[satpaul]

@manodwhb 

For Eg Input data

emp.dat

id|Name|sal

1|AA|100

2|BB|200

3|CC|

OUTPUT

id|Name|sal

1|AA|100

2|BB|200

but i need the whole records in parquet format

id|Name|sal

1|AA|100

2|BB|200

3|CC|empty string

in tmap i have used for that column if else but null records not coming.

i have attached the file.

[manodwhb]

@satpaul , you need to use the below way for an empty string. have you used in tmap enable filter in the output section?

possible share you job design.

row1.RISK_PCT==null ? "":row1.RISK_PCT

[satpaul]

@manodwhb 

i already used this.

Attached the screenshot for the same.

Capture1.PNG