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.

[Digvijay_Singh]

Your data file has 9268 records in your attached file? See the count at the bottom of below image.

[pnn44794]

Sorry about that.  Not sure what happened.  I'm running another export and will check it before attaching it.  Do you know if there is a size limitation for attachments?

[Digvijay_Singh]

You mean along with replies here?

I see this when I try to attach any file -

[pnn44794]

Ok.  That's weird.  I added RowNo(TOTAL) as an expression and it shows 9,268 on the last row.  I exported it and that's what is there.

[pnn44794]

Ok.  It looks like it's all there now.  I'm not sure what happened the first time I attached it.

[pnn44794]

Any ideas or is what I'm looking for not doable?

[vishsaggi]

I can still see 9269 rows in this excel sheet is that correct? 

[Digvijay_Singh]

Are All the fields in your straight table are coming from same table or different table? Is the network zone is coming from separate table? You would want to check for the duplicates or no match of the keys associating those tables if they exists in separate table, they might result in extra rows in your straight table.

[pnn44794]

That is how many that are in the spreadsheet.  Before I added the Network Zone dimension, there was 7,330 rows.  That's how many that should be there after adding the Network Zone dimension and not 9,268.