Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] File Listener
 Login/Join
 
Platinum Member
posted
Hi,

I am using File Listener to get some csv files at a particular folder location and load those to a target table.
It is successful and i use SOURCE_FILE_NAME as an INSTANCE to get the source file name in the target table.
So when i use this dataflow in my process flow,how can i grab the source file name.?
I need to include the source file name in a procedure to store the log regarding each dataflow.
Can i grab the SOURCE_FILE name out of data_flow.?

This message has been edited. Last edited by: FP Mod Chuck,


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 118 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Srajeevan

After the data flow completes you can have a stored procedure that reads that column out of the target table, hold the results and then do a -READFILE of the hold file into a variable and then reference the variable in your procedure.


TABLE FILE TARGET_TABLE
PRINT SOURCE_FILE_NAME
WHERE RECORDLIMIT EQ 1
ON TABLE HOLD AS SOURCE_FILE_NAME FORMAT ALPHA
END
-RUN
-READFILE SOURCE_FILE
-RUN
-SET &&SOURCE_FILE_NAME = &SOURCE_FILE_NAME;


Using a global variable so it will be available in your subsequent procedure.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1091 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Chuck,

I will try the solution you provided and then close the post as solved.

Thanks again
Sreejith


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 118 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.