BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

[DI] Importing Files


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
fblau
Principal Member
Principal Member



Joined: 07 Feb 2005

Posts: 220



PostPosted: Tue Feb 08, 2005 3:00 am 
Post subject: [DI] Importing Files

I have a table (STG_FILENAMES) that I want to use a source for importing all of the date in the files in the column (FILENAME) to a table STG.

Additionally, there is a column called SOURCE_SERVER that I would like to have as a variable to use in the insert statement.

For the life of me, I can't figure this out.

I have the filename set as $FILENAME that is set in a lookup_ext function in a script... but it only reads and imports the first record.

How do I get it to loop through ALL of the records?
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10591
Location: Germany


flag
PostPosted: Tue Feb 08, 2005 4:16 am 
Post subject: Re: Importing Files

The lookup tries to find ONE value per call. So I assume your job is designed so that the lookup is executed only once, reading the entire file and returns the row matching the best.

The way you wrote it I assume you want to read all the records and process them all, thus you would use the fileformat (drag drop it on the dataflow as source) and specify as the filename $filename there.

Did I guess right??????????

Werner

_________________
Werner Daehn
Product Manager Data Services
SAP AG
�The opinions expressed in this post are my own views and not those of SAP.�
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0412 seconds using 17 queries. (SQL 0.0142 Parse 0.0009 Other 0.0261)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo