CODEWITHSUNDEEP
csvziptalendtalend-mdm
Jess
Jess

Reputation: 107

Import a zipped csv file into Talend

Is it possible to import a zipped csv file directly into Talend Open Studio for Big Data 6.3.0.2, if not would there be any work arounds?

Upvotes: 1

Views: 1203

Answers (1)

E LaRoche
E LaRoche

Reputation: 1134

Yes, but in two steps.

Step 1. In the file management section of the components is a tFileUnarchive component. You can use this by first placing a tFileList component and connecting it to the tFileUnarchive with the iterate connector.

Step 2. The unzipped files will be moved to an output directory you specify. You can then use another tFileList to read those files in, within the same job.

If you find Talend moves quicker than the unzipping process or files are locked you can put in a tSleep and wait a few seconds or minutes. I use the tSleep in cases where we need a pause in processing to allow system resources to catch up with the job.

Upvotes: 1

Related Questions