Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

drop table before inputdelimited upload

I am runnnig TOS 1.1.2.r2022 and would like to know how to drop a mysql table prior to reading in from a txt file. my input is a tFileInputDelimited and my output tMysqlOutputBulk, i know that in the newest release that there is an option to drop a table within the tMysqlOuputBulk properties but i cannot use this version as it hangs on me when i try to define a delimted schema (the wizard hangs previewing the txt file).
Any ideas?
Ben
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Simply add a tDBSQLRow with a "DROP TABLE XXX" and a RunBefore Link to your tFileInputDelimited