drop table before inputdelimited upload

One Star Ben
One Star

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
Employee

Re: drop table before inputdelimited upload

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch