How to get max(date) for just one of linked tables

[aresb]

Hi all,

i'm stuck with a problem when getting max(id_date) for a specific sheet.

I have two tables linked with a simple link table format, and they both have id_date among their common id's

Table A, used in sheet 1, has max(id_date) = 20221231, while Table B, used in sheet 2, has max(id_date) = 20230131.

In sheet 1, when i put the sheet action for preloading all data on max(id_date), it will take into account 20230131, that is indeed

max for link table, in this case id_date of table B, not used in sheet 1.

Is there any discrimination, for  example with set expressions, to discriminate max(id_date) taking into account just one of the linked tables?

Thank you

[ogster1974 · Accepted solution]

Add a factType field to your link table identifying if the data is sourced from tableA or tableB then you can include the following in your set analysis.

max({<factType={'tableA'}>} id_date)