Table Visualization does not display data columns after null in join

Jimmy, (v-yuta-msft)

I was referring to moving the column that fails to obtain data (see "Condition Assessment" below) to the far right in the table visualization. Any field to the right of this column will not display any data. Fields to the left will. As the failing column is moved up/down the field list (left/right visually), one can see data disappear that was once displaying or reappear, depending on whether it is to the left or right of the failing column. If the failing column is moved to the far right side of the visualization (last in the field list), all fields will display, except the data in the failing field.

The field Condition Assessment is from a joined table. The two rows circled do not have a record in the table containing condition assessments. The fields Est. Date of Condition Assessment and Primary Mode display when they are to the left of Condition Assessment.

However the fields Est. Date of Condition Assessment and Primary Mode do not display when they are to the right of the field Condition Assessment. The failure to display data is only on the row that does not have a record in the right half of the join from the table of condition assessments.

I hope this explains the issue better. I don't think this behavior is correct and hope it can be resolved. If there are further questions, please post them.

Regards,

Martin Batistelli