From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

Exporting records into files

Highlighted
Five Stars

Exporting records into files

incase i have 10000 records and i want to export 2000 records into one file and 4000 Records into another File? How can we export records separately?

Accepted Solutions
Highlighted
Community Manager

Re: Exporting records into files

Add a sequence id for each row if there is no sequence id in source data, and use this sequence id to filter the rows.
To do: (for example)
tFileInputDelimited--tMap1-out1--tfile1
-out2--tfile2
Hope it helps you!

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

View solution in original post


All Replies
Highlighted
Community Manager

Re: Exporting records into files

Hi 

Do you want to filter the records based on condition or just random output the records in a file?

 

Regards

Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
Five Stars

Re: Exporting records into files

just a random output records of a file which is exported into separate
files.
Highlighted
Community Manager

Re: Exporting records into files

Add a sequence id for each row if there is no sequence id in source data, and use this sequence id to filter the rows.
To do: (for example)
tFileInputDelimited--tMap1-out1--tfile1
-out2--tfile2
Hope it helps you!

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

View solution in original post

Highlighted
Five Stars

Re: Exporting records into files

Thanks a lot👍🏽👍🏽👍🏽

2019 GARTNER 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

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads