QlikView ETl Loading

[Anonymous]

We are getting Data in .txt Sources while loading into QlikView some columns are Having

From Source

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

#N/A

'

-

Null

After loading

Qlikview View Output

0

0

0

0

0

0

0

0

0

0

Dont need too show #N/A as 0 show as #N/A 

[its_anandrjs]

In your load script for that field try to add Text(FieldName)   and then reload the table again

try like  this

Ex:-

Load

Text(FieldName)  as Fielname //For #N/A and other related rows

From Location;

Regards

Anand

[Anonymous]

Thanks Anand for quick response if same column has null and special characters need to show an error while loading data in to QlikView any possiblities are there

[its_anandrjs]

If there is null values then in which format they saved in data you have to interpret that like i assume it is 0 then try with If(Len(FieldName) = 0, Null(), Text(FieldName) ) as NewField you have to do multiple transform for this and may be NULL value handling also.

Regards

Anand

[#5]

Hi,

Alt(fieldname,0)