Focal Point
[SOLVED] Load Multiple Excel into WF table

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/7777012086

January 11, 2016, 02:40 AM
Maran
[SOLVED] Load Multiple Excel into WF table
Hi Team,
I have a requirement for automation process. Need to read around 6 excel\csv files from particular path(local or FTP) and load the data in single table. based on that table need to create a report. this is daily process. Every day morning some one place the excel\csv in path.

below are details process flow.
Step 1: Read the Excel\CSV files from particular path.
Step 2: Filter the data based on conditions.
Step 3: Join the filtered data to another table and load the final data in server.
Step 4: Create a excel report based on above table. (Report can be created using Developer studio)
Step 5: Send the Excel output to group of user thru Email. ( we can schedule report in report caster)

Need to automate first 3 steps.(like MS SSIS package)
How to achieve this process using WF\Data Migrator.

Please help me on this.

This message has been edited. Last edited by: Maran,


WebFOCUS 8201m
Windows,AppStudio, DevStudio,All Outputs
January 15, 2016, 06:13 AM
Ricardo Augusto
http://forums.informationbuild...1057331/m/4597012086


WebFOCUS 8.1.05 / APP Studio