Solved: Find specific [survey_status] for an asset that ha... - Page 2

Jake_Naude · 05-31-2020 03:49 PM

Evening… Please could someone point a newbie in the right direction?

I need to look at [asset_name] and find the most recent [survey_status] in the survey table below which has updates & adds permissions:

And then put it in [survey_status] against [rfdesign_source_asset_name] in the rf_design table below which only has updates permissions:

Thanks in advance…

Bahbus

LOOKUP(
  MAXROW(“survey”,“_ROWNUMBER”,
    IN([_THISROW].[rfdesign_source_asset_name], [asset_name])
    ),
  “survey”,
  “id”,
  “survey_status”
)

View solution in original post

Find specific [survey_status] for an asset that has many records