Garbage rows in Qlik table

[Pragya]

Hi there, 

My code in data load editor looks like this:

Student:

NoConcatenate

Load

StudentID,Status 

From filename1;

Test:

NoConcatenate

Load

StudentID, Testtaken

From filename2;

I want the data following way:

StudentID   Status   Testtaken

1                    Present  Yes

2                    Absent    No

Instead I am getting the data this way:

StudentID   Status   Testtaken

1                     Present      -

1                     -                      Yes

2                  Absent         -

2                  -                             No

Could someone suggest how to remove this garbage data?

Thanks

[sidhiq91]

@Pragya  Please see the code below:

NoConcatenate
Temp:
LOad * inline [
StudentID, Status
1,Present
2,Absent

];

inner join (Temp)
LOad * inline [
StudentID, testtaken
1,Yes
2,No
];

Exit Script;

If this resolves your issue, please like and accept it as a solution.

[Pragya]

Hi Sidhiq91, 

This was just an example. My real code has 300 plus fields and 1M rows in it. 

Can we find some solution without inputting values?

Also i can do left join but not inner join as student file is a main file connecting to other files.

[PrashantSangle]

You are getting this output because of Concatenate 

Concatenate will append rows. It will not merge in one rows

You have to use join these 2 table. Use join whichever solve your problem

Qlik support Left, Right, inner, full join

Sample solution

Noconcatenate

Student:

Load

StudentID, Status 

From filename1;

Join                    // if no join type mention then it is full join

Load

StudentID, Testtaken

From filename2;

Regards,

Prashant Sangle

[vinieme12]

You need to Join the two data sets

Refer this article

https://community.qlik.com/t5/QlikView-App-Dev/Understanding-Join-Keep-and-Concatenate/td-p/328379