Returning Too Many Rows When New Dimension Is Added

[pnn44794]

Hello:

I have a straight table where I need to add a new column called Network Zone.  Before I add Network Zone, I have a total of 7,330 rows of data.  After I add Network Zone, I get 9,268 rows of data.  The row count should not change.  I believe I may need to add Network Zone as a calculated dimension perhaps, but I'm open to suggestions.  I say calculated dimension so I would have the ability to put the column wherever I'd like to.  If there is no value for Network Zone, that's fine as it can be blank for a row.  I have attached a spreadsheet that includes Network Zone that results in 9,268 rows which is incorrect (again, should be 7,330 rows).

As always, thanks in advance for any and all help and responses.

[vishsaggi]

When you say you are adding Networkzone dimension, can you show the script where you adding this dimension field?

[Digvijay_Singh · Accepted solution]

Before adding Network Zone, did you have such duplicates? I see no difference other than 2 network zone values(Space and ESF), you can match this with the file without network zone, if you see one record, means your number of records are getting increased due to undesired data model associations. It would be my bad if I missed finding the difference or you had two such records before as well.

[pnn44794]

It's just one line of many.

Or are you asking to see the whole load script?  As an FYI, I'm about to go offline but will be back online in about an hour.

[pnn44794]

Before adding Network Zone, I had no dups.  I think you're right.  It's my data model.  Network Zone does indeed come from another table, though both tables are linked by ORDER_ID.  However, I think I may be using the wrong one.  There's a few.  As mentioned in my response to Vishwarath, I'm about to go offline for about an hour and will be back on then.  I'll try a different Order ID field.

[vishsaggi]

I wanted to know if you were adding this column in the script and generating data to Excel?

[pnn44794]

Yes. I am loading the dimension via the load script, adding the dimension to a straight table and then exporting the data from Qlikview to Excel. My end users access this dashboard and often want to export the data to Excel.

[vishsaggi]

As Vijay mentioned please check your data model and see how many rows are matching to your networkzone dimension table.

[pnn44794]

Hello Digvijay:

My apologies for the delay in getting back to you.  You are correct.  I have a problem with my data model that I need to fix.  I will mark your answer as correct.  Thank you for responding to me.

[pnn44794]

Hello Vishwarath:

My apologies for the delay in getting back to you.  As you mentioned, Digvijay is correct in that I have a problem with my data model which I'll have to fix.  Thank you for responding..