Values disappear when changing colum order in table

[Anonymous]

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

[Anonymous]

Hi MahyarTF, 

This is my data model,

It is also weird for me and not sure why

Thanks

[MahyarTF]

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

it is weird.

Appreciate for Kudos

[MahyarTF]

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 :