Qlikview inserts a blank row in concatenation of two tables

[#1]

Hi,

I have a table named Data.  I tried concatenating two of the rows into one table.  My code is shown below:

But I noticed that Qlikview inserts a Ranking = '-'.  Can anybody tell me why this is and how to fix it?

Would appreciate any help.

Thanks.

Joel

[sunny_talwar · Accepted solution]

Try adding a where statement

MRB:

LOAD 'Financial Reward' as Factor,

          [Financial Reward] as Ranking

Resident Data

Where Len(Trim([Financial Reward])) > 0;

Concatenate (MRB)

LOAD 'Prestige' as Factor,

          Prestige as Ranking

Resident Data

Where Len(Trim(Prestige )) > 0;

[#3]

Hi Sunny,

Thanks for your reply but the code didn't work.  I still have the "-" values in the Ranking field.

It's weird that if I load a single table I get values = 1,2,3,4,5,6 and no "-" values.

Hmmm...

[#4]

Hi Sunny,

Figured it out.  Just modified your code into:

     WHERE NUM([Financial Reward]) > 0

Thanks for your help.

Joel