topic Re: How to handle null values while Converting .dat file to parquet file in Talend Studio

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

satpaul — Sat, 16 Nov 2024 02:06:02 GMT

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 — Mon, 22 Jun 2020 07:38:16 GMT

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

satpaul — Mon, 22 Jun 2020 11:08:49 GMT

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 — Mon, 22 Jun 2020 11:56:50 GMT

@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 — Mon, 22 Jun 2020 13:35:21 GMT

i already used this.

Attached the screenshot for the same.