Dynamic Input SQL Update multiple clauses

Hello community,

Sorry for the long post but please stay with me..

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,

Thanks, James

snip issue 3.png

snip issue 2.png

snip issue 1.png

Accepted answers

patrick_mcauliffe

The issue is likely your sql statement of the dynamic input.

Does your Where clause use an "=" or an "in"?
It should be an "IN ('123456789')" and then replace the 123456789 and the option to group replacement value for sql in clause.

All comments

patrick_mcauliffe

The issue is likely your sql statement of the dynamic input.

Does your Where clause use an "=" or an "in"?
It should be an "IN ('123456789')" and then replace the 123456789 and the option to group replacement value for sql in clause.

JamesBills

Hi Patrick.

Just so I'm clear would your solution be appending the date onto the list of cars.

Then having the SQL clause say IN (123456789) AND ....= (date)

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15873

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703