Forum Discussion
Helper IIITable 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 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...
It appears fine for me.
4 Replies
- Ashish_Mathur
Super User
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.
Kirt1965Here 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
It appears fine for me.