Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to skip more then 1 line in text file importing ?

Alvaro SoaresSep 2 2015 — edited Sep 2 2015

Hi All,

I am facing an issue with text file importing in ODI and would ask for some help here.

I have four text files (inside these files the fields are separated with ";" ). The first one have a particular point. I mean it has a header with 45 lines and the fields begin at line 46 but the others files (file2, 3 and 4) has its header at line 1 at top of file.

When I created a Data Store for the first one (with 45 lines header) I've set "45" at Heading (Number of Lines) field at Files option. However, when I run the interface with this Data Store maped it is messing everything and the 45 lines are not been ignored.

So, is there another LKM should I have to use to import a text file that has more than 1 line as header?

Thanks in advance.

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2015

Added on Sep 2 2015

#business-intelligence-applications, #data-integrator, #system-management-and-integration

7 comments

1,247 views