Forum Discussion

Icon for Helper III rank

Helper III

3 years ago

Solved

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

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...

Ashish_Mathur
3 years ago
It appears fine for me.

Icon for Helper III rank

Helper III

3 years ago

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.

Icon for Super User rank

Super User

3 years ago

It appears fine for me.

Kirt1965
Helper III
3 years ago
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.

Related content