topic Extra Row on using Aliases during Resident Load in QlikView

Extra Row on using Aliases during Resident Load

Fri, 11 Apr 2014 19:41:28 GMT

I have the following script

Level1:
noconcatenate load
Container1,Area1,Ref1,Inlet1,AggrType,Sub1,SubArea1,Wt1
resident
Level1Area;

drop table Level1Area;

Following data in straight table (from Level1) :

Container1	Area1	Ref1	Inlet1	AggrType	Sub1	SubArea1	Wt1
GHX456	LP	GHX	20	G	HX723	LP	0.857467
GHX456	LP	GHX	20	G	HX722	LP	0.857467
GHX456	LP	GHX	20	G	HX721	LP	0.857467

Level2Area :
Load Sub1 as 'Container2', SubArea1 as 'Area2', Wt1 as 'Inlet2'
Resident Level1 ;

For some reason I am getting the extra row in the Level2Area table (in red below), which I am not sure why it is coming and how I could eliminate that.

Container2	Area2	Inlet2
HX723	LP	0.85747
HX723	LP	1
HX722	LP	0.85747
HX722	LP	1
HX721	LP	0.85747
HX721	LP	1

Re: Extra Row on using Aliases during Resident Load

its_anandrjs — Fri, 11 Apr 2014 20:00:06 GMT

I dont thing there is any mistake when i read Level1 data i dont get that rows may be check individually each field there is duplicate records or not.

Regards

Re: Extra Row on using Aliases during Resident Load

Fri, 11 Apr 2014 21:16:34 GMT

Thanks I found the duplicate records . I had wrong filters earlier because of which I was not able to see them.

Re: Extra Row on using Aliases during Resident Load

its_anandrjs — Fri, 11 Apr 2014 21:23:29 GMT

Thanks check with this Inline sample load of your table

Level1:

LOAD * INLINE [

Container1, Area1, Ref1, Inlet1, AggrType, Sub1, SubArea1, Wt1

GHX456, LP, GHX, 20, G, HX723, LP, 0.857467

GHX456, LP, GHX, 20, G, HX722, LP, 0.857467

GHX456, LP, GHX, 20, G, HX721, LP, 0.857467

];

Level2Area :

Load Sub1 as Container2, SubArea1 as Area2, Wt1 as Inlet2

Resident Level1;

and there is no necessary that you give alias name as within single cots just give name as Fieldname as Container2 same for others.

Regards