Table visualization - same row displaying twice

[jerryr125]

Hi - I have a table visualization showing the following (as an example):

Location     Quantity     Comments

-------------  ------------    ----------------

LOC01       100                  -

LOC02       2000               -

LOC03       545                 quantity from abc inc.

LOC03      545                   -

The 'comments' is in another table (one occurrence BUT not every location has a comment).

Since LOC03 has a value in the 'comments' fields, it is now displaying  twice in my visualization (as seen above).

How can I remove the second occurrence of LOC03 and still keep LOC01, LOC02, and LOC03 in the table visualization ?

Therefore, the outcome would be :

Location     Quantity     Comments

-------------  ------------    ----------------

LOC01       100                  -

LOC02       2000               -

LOC03       545                 quantity from abc inc.

Also, the comments fields is a dimension since I am using an if statement to pull the comments from another table.

It works fine - the issue is the appearance of the second occurrence.

Thanks - Jerry

[jerryr125]

Hi - any thoughts  on this ? Thanks - Jerry

[Gysbert_Wassenaar]

Well, the rows are not duplicates because they differ. One has a value in the Comments field and the other does not. If you want only one row you will have to use a measure that aggregates the values in the Comments field. Perhaps MaxString(Comments) works for you.

[jerryr125]

Hi - 

I currently have in the column (dimension) the following formula:

=IF([materialid]='mat01',(comment))

If I add MaxString to the formula (again, in a column that is a dimension):

=IF([materialid]='mat01',MaxString(comment))

I get an error - invalid dimension

[jerryr125]

I tried this as well:

=IF([intrppematerialid]='ppemat01',aggr(maxstring(intrcomment),intrcomment))

no luck - same results - thoughts ?

[Gysbert_Wassenaar]

Try removing the dimension and adding a measure.

[jerryr125]

Hi I removed the dimension and added the following as a measure:

=IF([intrppematerialid]='ppemat01',aggr(minstring(intrcomment),intrcomment))

Still no luck

[Dalton_Ruer]

Simply use MaxString(Comments) as the expression for the comments field unless there is some reason you literally only want to only show that particular location one time but if the others had multiple comments you would want to see them.