Teach me how to display measure_time value from another table(cloud database)

[gidae]

 [ Goal ] : What I want to do

           1 . show measure_time (ex.2023-08-28 14:20:00)

           2 . show measure_value (ex.1024)

[ Descriptions ]

• I have two tables on appsheet
  • TARGET
  • tb_nbiot_quality_data_now (cloud database)
• Both tables have key(CTN & ctn) values ​​in the same format. ( ex. 01240917741)
• I tried with the vlookup formula, but haven't found a way yet.

[ DataSet : TARGET ]

The formula I tried here is: LOOKUP([CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")

but not work.

 [ DataSet : tb_nbiot_quality_data_now (cloud database) ]

[ REQUEST ]

Teach me how to display measure_time value from another table(cloud database)

[Suvrutt_Gurjar · Accepted solution]

---

@gidae wrote:

The formula I tried here is: LOOKUP([CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")

---

I believe you need to try 

LOOKUP([_THISROW].[CTN], "tb_nbiot_quality_data_now", "ctn", "meas_dt")

Please take a look at the "Troubleshoot" section in the help article below to understand the need for the use of [_THISROW]

LOOKUP() - AppSheet Help

[Suvrutt_Gurjar]

Also if you are displaying many values from one table into records of other table on a continuous basis, please consider referencing relationship between two tables instead of pulling values through LOOKUP() or SELECT() etc.

References between tables - AppSheet Help