Hi all,
Due to the following Excel formula:
=“INSERT INTO MICASA.MICASA VALUES (’”&A2&"’,‘001’,’"&C2&"’,’"&SI(ESBLANCO(E2);"####";E2)&"’,’"&SI(ESBLANCO(G2);"####";G2)&"’);"
I’m trying to add a new job in UIpath with Write cell excel but when i try to copy the full query is giving me some compilation error. As I undertand, seems like there are a lot of " and Uipath don’t know how to manage in terms of dicrimine if is formula , string or whatever. Please , could you help me in order to compose this formula?
Thanks