Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)