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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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