Skip to Content

Synopsis: This will be a step by Step tutorial on reading multiple files simultaneously using a single file format.

Two tab delimited flat files of identical format are available. They need to be extracted using BODI and the data needs to be pushed to the same table. The files source_1.txt and source_2.txt as shown in the below diagram are taken for demo purpose.

/wp-content/uploads/2013/03/sources_2_192504.jpg

In the file format, mention both the file names separated by comma.

/wp-content/uploads/2013/03/file_format_2_192505.jpg

Using this file format, data from both the file formats are extracted at one go.

/wp-content/uploads/2013/03/df_2_192510.jpg

Similar Options: A filename containing a wildcard character can also be used to read multiple files. In the above example, instead of using “source_1.txt, source_2.txt” as filename, you can also use “source_*.txt” to extract multiple files with similar naming convention.

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Arun Kumar

    Debapriya,

    Thanks for the post, your example similar to what we do daily in our development environment. We are calling 44 text files using wild characters *.txt in filename field from a folder. Records of all the files are output to a table in sql server before transformation.

    Arun

    (0) 
  2. sapkrisboedge mac

    Hi Priya,

    Thanks for the Post, it is good Example ..

    I have one Question for you..

    I saw the BODS 3.0/4.0  Service packs, Can you please let me know what is the BODS 4.0 SP1,SP2,SP3 and SP4. It is added any new contents BODS 4.0 Service packs..

    Please replay me ASAP..

    Thanks,

    Krishna..

    (0) 
  3. Ramachandra Reddy

    Hi DebaPriya,

    My Source is .CSV File and i have taken the faltfile format.

    There i have given the root path and the filename in the first time it is asking me for “OVERWRITE THE CURRENT SCHEMA WITH THE SCHEMA FROM THE FILE YOU SELECTED”  after 2 days i have taken the another file but this time it is not asking for the schema overwriting.

    Could you please assist me on this one.

    Thanks,

    Ramachandra.

    (0) 

Leave a Reply