Forum Discussion

Nourhassan's avatar
Nourhassan
Icon for Helper I rankHelper I
5 years ago
Solved

Joining columns in one table

Hello,

 

I have a problem when I am trying to join some columns from different tables.

 

I want to show a table with columns from several tables. These tables are in a relationship. When I am inserting all wanted columns into the Dashboard table, then I get for the first rows some empty records. I only want to show rows with merged records and without empty cells. The picture shows the empty rows/cells before showing merged columns.

 

Thanks,

Nour

 

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Nourhassan ,

     

    the rows have values for other columns, like "Work Category", for that reason they are showing.

    As a quick fix you can select the table and in the filter pane set the value for "ContractorName" to "is not blank":

     

    Then the blank rows for "ContractorName" should be removed from that visual.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

  • selimovd's avatar
    selimovd
    5 years ago

    Hey Nourhassan ,

     

    could you solve the issue with the filter for "is not blank"?

    I'm curious if you could solve this issue 🙂

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

4 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Nourhassan ,

     

    the rows have values for other columns, like "Work Category", for that reason they are showing.

    As a quick fix you can select the table and in the filter pane set the value for "ContractorName" to "is not blank":

     

    Then the blank rows for "ContractorName" should be removed from that visual.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

    • selimovd's avatar
      selimovd
      Icon for Most Valuable Professional rankMost Valuable Professional
      5 years ago

      Hey Nourhassan ,

       

      could you solve the issue with the filter for "is not blank"?

      I'm curious if you could solve this issue 🙂

       

      If you need any help please let me know.
      If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
       
      Best regards
      Denis
       
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Nourhassan 

    You can change the settings in visual format .Turn off the function Show items with no data ,then you will not see the blank rows .

    Original data:

    The effect is as shown:

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • selimovd's avatar
      selimovd
      Icon for Most Valuable Professional rankMost Valuable Professional
      5 years ago

      Hey Anonymous ,

       

      that's in general true, but it wouldn't help in this case.

      There are columns that contain data for specific rows, so they would show anyways.

       

      Best regards

      Denis