Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Values disappear when changing colum order in table

Hi all,

Table 1 and table 2 have 1_to_many relationship  and data is showing in the table below and correct.

Columns are selected to "show items with no data" same as LEFT JOIN in SQL. This means that data in Table 1 is still showing even Table 2 have empty values.

 

However, when I swap two last columns  "Table 1_Moisture" and "Table 2_Moisture", then values of Table 1_Moisture disappeared as the screenshot (question marks) below.

I want these values still appear when changing the column order

 

Thanks

 

 

 

 

3 Replies

  • MahyarTF's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member

    Hi,

    Not sure what is your sample data and your data-model,

    But I tried to simulate the scenario for myself and it seems all correct :

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi MahyarTF, 

    This is my data model,

     

     

    It is also weird for me and not sure why

    Thanks

    • MahyarTF's avatar
      MahyarTF
      Icon for Memorable Member rankMemorable Member

      I saw your data model, My sample is the same.

      it is weird.

       

      Appreciate for Kudos