Table visual - show data from one table even if no data in a linked table

[Kirt1965]

Hi All,

Feel this should be simple, but the solution is evading me. 

I am building a report having to do with timecards.  Timecard data for employees exists in one table.  Comments related to those timecards exists in another table.  I want to show certain timecard data for employees in the table visual and that works fine.  However, I also want to show associated comments for the timecards.  This is where the problem occurs.  If a particular timecard has no comments, then all rows of timecard data fail to show in the visual as soon as I add the comments column to the visual.  What I want is for all the timecard data to continue to show even if there is no comments in the joined comments table.

I hope this makes sense.  If not, I can try to clarify.

Thank you...

[Ashish_Mathur]

Hi,

Share some data to work with (in a format that can be pasted in an MS Excel file) and also show the expected result.

[Kirt1965]

Here you go...  You'll see Donald Duck has no comment.  I want his timecard data to show in the table visual despite the fact there is no comment, but all I get are Mickey's and Wile's data in the visual.

Timecard Data
TcID	Employee	COCS Description	Charge Code	Att Code	Charge Date	Hours	Last Update
8429509	Mouse, Mickey	JANITOR / CLEANER	600532	RW	11/8/2022	0.50	10/18/2022
8429509	Mouse, Mickey	JANITOR / CLEANER	600532	RW	11/7/2022	0.50	10/18/2022
8429509	Mouse, Mickey	JANITOR / CLEANER	600534	RW	11/8/2022	1.50	10/18/2022
8429509	Mouse, Mickey	JANITOR / CLEANER	600534	RW	11/7/2022	1.50	10/18/2022
8429509	Mouse, Mickey	JANITOR / CLEANER	603160	RW	11/8/2022	8.00	10/18/2022
8429509	Mouse, Mickey	JANITOR / CLEANER	603160	RW	11/7/2022	8.00	10/18/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/28/2022	8.00	10/2/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/27/2022	8.00	10/2/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/26/2022	8.00	10/2/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/25/2022	8.00	10/2/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/24/2022	8.00	10/2/2022
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/27/2022	10.00	10/20/2022
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/26/2022	10.00	10/20/2022
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/25/2022	10.00	10/20/2022
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/24/2022	10.00	10/20/2022

Comment Data
TcID	Comment
8429509	Cleaned Donald's stinking hole in the ground all day.
8430487	Created elaborate piping system to catch that pesky roadrunner.

Expected Result Inside Table Visual
TcID	Employee	COCS Description	Charge Code	Att Code	Charge Date	Hours	Last Update	Comment
8429509	Mouse, Mickey	JANITOR / CLEANER	600532	RW	11/8/2022	0.50	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	600532	RW	11/7/2022	0.50	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	600534	RW	11/8/2022	1.50	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	600534	RW	11/7/2022	1.50	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	603160	RW	11/8/2022	8.00	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	603160	RW	11/7/2022	8.00	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/28/2022	8.00	10/2/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/27/2022	8.00	10/2/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/26/2022	8.00	10/2/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/25/2022	8.00	10/2/2022
8411725	Duck, Donald	SUBSTATION ELECTRICIAN	600222	RW	10/24/2022	8.00	10/2/2022
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/27/2022	10.00	10/20/2022	Created elaborate piping system to catch that pesky roadrunner.
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/26/2022	10.00	10/20/2022	Created elaborate piping system to catch that pesky roadrunner.
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/25/2022	10.00	10/20/2022	Created elaborate piping system to catch that pesky roadrunner.
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/24/2022	10.00	10/20/2022	Created elaborate piping system to catch that pesky roadrunner.

Actual Result
TcID	Employee	COCS Description	Charge Code	Att Code	Charge Date	Hours	Last Update	Comment
8429509	Mouse, Mickey	JANITOR / CLEANER	600532	RW	11/8/2022	0.50	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	600532	RW	11/7/2022	0.50	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	600534	RW	11/8/2022	1.50	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	600534	RW	11/7/2022	1.50	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	603160	RW	11/8/2022	8.00	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8429509	Mouse, Mickey	JANITOR / CLEANER	603160	RW	11/7/2022	8.00	10/18/2022	Cleaned Donald's stinking hole in the ground all day.
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/27/2022	10.00	10/20/2022	Created elaborate piping system to catch that pesky roadrunner.
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/26/2022	10.00	10/20/2022	Created elaborate piping system to catch that pesky roadrunner.
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/25/2022	10.00	10/20/2022	Created elaborate piping system to catch that pesky roadrunner.
8430487	Coyote, Wile E	PIPEFITTERS	600302	RW	10/24/2022	10.00	10/20/2022	Created elaborate piping system to catch that pesky roadrunner.

[Ashish_Mathur · Accepted solution]

It appears fine for me.

[Kirt1965]

I, too, got it to work, so I don't know what was the original problem.  I started over, so I did something wrong in the original file.  Thank you for your time.