Hi all! I currently have 2 tables, one for project status updates and another table for archived project status updates. Both tables have the same set of columns I need to find the latest status update from both tables for a project.
What I did was listcombine both tables but then I would only see the items from table 1, not table 2. From there, I won’t be able to get currentvalue for table 2. How can I find the values for table 2 in a listcombine?
Hello @mattics ,
Unless you have tens of thousands of rows, you should have one table and an extra column (for example a check box) to indicate a project is archived. You can create different views, each with it’s own filter, for archived and non-archived projects.
You can also create a view with a filter to show the latest update for archived and/or non-archived projects.
It is hard to help you further without having any idea of the data structure of your table. If you share a (dummy) doc with some representative data, I am sure you will get some suggestions from the community.
I think listcombine is not the way to go, unless you want to produce a text-only output on your canvas (and even then I don’t think it is the way to go.
Greetings,
Joost