Split Mysql table on date column and store result in different tables with dynamic name such as filesplit_2016-01-01

Four Stars

Split Mysql table on date column and store result in different tables with dynamic name such as filesplit_2016-01-01

Hi there,

 

I am trying to split a Mysql table based on a date column. If there are n distinct dates in the input table, n different tables must be created with the table name as filesplit_<date> for e.g : filesplit_2016-01-01.

 

My job designer has the components linked as in the screenshot attached SplitTable1.PNG.

 

The output tables are created but, it only takes in 1 row as input. This problem does not arise when I save the outputs in csv files.

 

Community Manager

Re: Split Mysql table on date column and store result in different tables with dynamic name such as filesplit_2016-01-01

Can you show the configuration of your output database component? Are you sure only 1 row is being added to the table? What you seen in the Studio after an "iterate" link is going to be the total rows per iteration. You will get an iteration per row from your database query

Four Stars

Re: Split Mysql table on date column and store result in different tables with dynamic name such as filesplit_2016-01-01

Thank you for the reply. 

I got a solution to this. Please find it in the link https://stackoverflow.com/questions/38921621/how-to-catch-errors-and-send-them-in-an-email-using-tal...

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download