if ((select counttColname] from Tablename$$] where Clasificacion] = 'A') > 1)
begin
Update Tablename$$] Set Status] = 'Test' where Colname] IN ('X','Y') and Clasificacion] ='A'
end
Can we use If and update together in AA360?
I want to identify if a set of values exists or not in excel table and then need to update status.
I have tried using the above code but it is throwing SQL syntax error.
How to achieve this or Is there any other approach ?