Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extra Row on using Aliases during Resident Load


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) :

                                                  

Container1Area1Ref1Inlet1AggrTypeSub1SubArea1Wt1
GHX456LPGHX20GHX723LP0.857467
GHX456LPGHX20GHX722LP0.857467
GHX456LPGHX20GHX721LP0.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.

                                                          

Container2Area2Inlet2
HX723LP0.85747
HX723LP1
HX722LP0.85747
HX722LP1
HX721LP0.85747
HX721LP1
1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

3 Replies
its_anandrjs

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

Not applicable
Author

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

its_anandrjs

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