Can I use the UPDATE or INSERT statements with Advanced Query?
I want to update records using the Advanced Query Command. How do I do this?
While the Advanced Filter Command supports SQL query statements, it currently does not support the UPDATE or INSERT SQL Commands. Only the SELECT statement along with complimentary statements such as JOIN, LEFT JOIN, RIGHT JOIN, etc. are currently supported. As a workaround, you can do the following:
- To Insert / Add Rows to a CSV
- Use the OneCloud Tabular Transformation BizApp and select the "Stack Files" Command.
- To Update Rows in a CSV
- Use the OneCloud Tabular Transformation BizApp and select the "Find and Replace" Command.
If you need additional support, please contact firstname.lastname@example.org.