Wrong Count in Straight Table

[#1]

Hi all,

my problem is a little bit hard to explain, but I'll try my best:

I'm retrieving data from different sharepointlists i.e. called prod issues, dev requests and team tracker. All these lists include different kind of dates and persons (example for prod issue: pic 1). They have similar columns but not identical ones. All they have in common is the requestor.

So far I was able to connect them with different loads using a flag. So if I click on production issues, I can see which kind of dates and persons are available.

My next step was to count the id, to see how many reports were opened/closed etc (depending on kind of date) at a certain month.

Here is my problem! It works fine with one exception: the "-" under column email (pic2). I really dont know where this comes from. It couldn't be a blank because they are counted in an extra row (count is correct). All the other counts are also correct except for the "-" which appears for each column. The only thing that adulterates my count. Therefore my line chart is also wrong...

Attached is also a part of my script code which should illustrate you my procedure.

I also tried resident load, load distinct... never the right solution.

Maybe its just an expression I have to add at the line chart and straight table...

Happy about any help! Thanks!

[Gysbert_Wassenaar]

The "-" means a null value. Those records don't have a value in the email field. The 'real' blanks are empty strings (or possible strings of x spaces). Those are not null values. The null values are probably created by combining the data with other tables. Your code example.txt doesn't show where TT_ID and DR_ID are coming from. Can you post an example document? You can scramble the data to ensure confidentiality:

• Preparing examples for Upload - Reduction and Data Scrambling.

[#3]

Thanks for your attention and also the scramble functionality! Attached my qvw file.

[Gysbert_Wassenaar · Accepted solution]

Whoa, that's not a very pretty data model. You've got a massive syntethic key table. That needs fixing. First try concatenating all the xml/data/row-xx tables into one table.

[#5]

Hi,

  Hope it is helpful.

[#6]

Somestimes it is so easy! This was the thing which fixed it. Thank you so much.