Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hi,
Alt(fieldname,0)