I need to do this activity:
- copy a information in a system (crtl+c)
- paste this information in a data base (crtv+v)
- insert a information in a system if this variable doesn’t exist in a data table
- if the variable exists, the bot can’t insert in the system
- if the variable not exists, the bot should insert in the system.
My bigger difficulty is for attach this variables in excel (in sequence, like a list), and then use this information in a condition.
I tried rank my variable 1 (crtl c) and variable 2 (excel data base), and used the function "variable2.contains(“variable1”) = TRUE (in IF condition), but doesn’t worked.
Can you help me please?