CSV File open with browse prompt: SQL WHERE Clause Synthax error

Hamilton (Venus)
1

Hello,
I designed a simple method where a user can browse, upload its CSV that contains 3 columns (Source plate, well, confluency)

I want to put Use a SQL Query to Enhance File Read:

image
image698×850 39.4 KB

I believe the variable is being treated as a string. I tried a few different synthax but no luck so far.
(I am following this tuto and doing it my way :wink:
https://raverobot.com/how-to-write-a-hitpick-method-in-hamilton-venus/

Is it possible to do it this way (i.e. link the file to a variable and put it in the Command String section)?

Thank you!

2

you can check this demo CSV_Query_Example_21Oct2022.pkg :: Hamilton,
VENUS SQL Help - Hamilton (Venus) - Lab Automation Forums

3 Likes
3

Apart from Robin’s example, you should use a variable to create your SQL string. The HslStr library is your friend here for inserting a variable into a string. Also, your 20 is a value and should be in si gle quotes, eg ‘20’.

2 Likes
4

Amazing, thank you very much!

5

Understood, thank you for the advice!