Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Talend Open Studio Cookbook

You're reading from  Talend Open Studio Cookbook

Product type Book
Published in Oct 2013
Publisher Packt
ISBN-13 9781782167266
Pages 270 pages
Edition 1st Edition
Languages
Author (1):
Rick Barton Rick Barton
Profile icon Rick Barton
Toc

Table of Contents (21) Chapters close

Talend Open Studio Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Introduction and General Principles 2. Metadata and Schemas 3. Validating Data 4. Mapping Data 5. Using Java in Talend 6. Managing Context Variables 7. Working with Databases 8. Managing Files 9. Working with XML, Queues, and Web Services 10. Debugging, Logging, and Testing 11. Deploying and Scheduling Talend Code 12. Common Mistakes and Other Useful Hints and Tips Common Type Conversions
Management of Contexts Index

Adding a header and trailer to a file


This recipe details a method for creating a file with a header and trailer record, which makes use of file append.

Getting ready

Open the jo_cook_ch08_0090_createHeaderAndTrailer job.

How to do it...

The steps for adding a header and trailer to a file are as follows:

  1. Open the tFixedFlowInput_1 component.

  2. Add the following for the field fileDate; TalendDate.getDate("CCYY-MM-DD").

  3. Open the tFixedFlowInput_2 component.

  4. Add the following for the field fileDate; ((Integer)globalMap.get("tFileInputDelimited_1_NB_LINE")).

  5. Open tFileOutputDelimited_1, and change the type to Append.

  6. Open tFileOutputDelimited_4, and change the type to Append.

  7. Run the job, and if you examine the output file, you should see that it has created a file with the current date in the header and the correct number of detail lines in the trailer.

How it works...

tFixedFlowInputs are used to generate a single row each for the header and the trailer.

The header sub job will create the file and add the...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime