topic Re: QlikView ETl Loading in QlikView

QlikView ETl Loading

Anonymous — Tue, 28 Oct 2014 07:40:23 GMT

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

From Source

#N/A

Null

After loading

Qlikview View Output

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

Re: QlikView ETl Loading

its_anandrjs — Tue, 28 Oct 2014 07:45:07 GMT

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

Re: QlikView ETl Loading

Anonymous — Tue, 28 Oct 2014 07:50:39 GMT

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

Re: QlikView ETl Loading

its_anandrjs — Tue, 28 Oct 2014 07:55:58 GMT

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

Re: QlikView ETl Loading

Tue, 28 Oct 2014 09:24:29 GMT

Hi,

Alt(fieldname,0)