All Forums Tools
toadrw 69 posts Joined 07/04
20 Jun 2016
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!

feinholz 1234 posts Joined 05/08
20 Jun 2016

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

toadrw 69 posts Joined 07/04
20 Jun 2016

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

You must sign in to leave a comment.