Easy Loader Skip Column in Flat File

Tools
Enthusiast

Easy Loader Skip Column in Flat File

Hello:

Is there a way to only load specific columns from a flat file using tdload?  Say my flat file has five columns, but I only need the last three.  Is there anyway to specify the first two columns as dummy columns or something equivalent maybe in the schema?  Thanks for your help!

2 REPLIES
Teradata Employee

Re: Easy Loader Skip Column in Flat File

This is not currently available with "tdload".

In order to do this, you would need a script so that the "SELECT" portion of the APPL-SELECT canbe used to filter out the unwanted columns.

The schema must contain all 5 columns because the schema defines what the data will look like as it arrives to TPT (so the file reader knows how to process the incoming records).

-- SteveF
Enthusiast

Re: Easy Loader Skip Column in Flat File

Thank you for the response Steve!  Appreciate your help once again!