This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I already have a database that i pull from, only when the date, is later than my last update. See photos. Use dynamic input tool for this. (each "car" in my data has multiple lines with different dates). This works at the moment...
But i want to only take this data for a certain amount of unique "cars".
(Each car has a unique identifier number, i.e. car 321456, 321457, etc).
There are ~4,000 cars which i want to take the data, around 2,000 which i don't.
The whole aim of this is to reduce time taken to run the workflow. Hence why i want to only pull for cars i need rather than pulling all then filtering.
Ideally i want a list of car numbers going into the query, and only pull data for them, and only after the right date (see top, currently working part)
If anyone has any extra time in lock down, some help on this would be much appreciated,