You can translate the question and the replies:

Creating multiple Extractors from one Sequence page

I am looking for assistance with an approach to create multiple records from the same web page arrived at using a Sequence generator in ITPilot. I am not sure this is best way to solve the problem, though; I am, thus, open to alternatives. Basically, I have the following page: http://www.freddiemac.com/pmms/data.html?week=28&year=2015&height=600&width=700. From this page, I need to create a record for each of the amortization plans (30-year, 15 year, 5/1-year and 1-year)--that is a total of four records--that combines rates, points and margins (where available) for each plan.Each record also needs to have the date at the top of the tables on the page. I envision the Output record to be like data_date, amort_plan, us_rate,ne_rate,se_rate,nc_rate,sw_rate,w_rate, us_points, ne_points, etc.
ITPilot extraction sequence
user
10-07-2015 16:17:21 -0400
code

4 Answers

Hello, I'm afraid the Express license does not allow the use of the ITPilot component. Please get in touch with our sales team to request a full evaluation license. Hope this helps.
Denodo Team
10-07-2015 18:30:56 -0400
code
Hi!, A possible solution to get the output you are looking for, could be like this: 1.- Use one Extractor to get just the date (data_date) 2.- Use another Extractor to get the rest of the values. In this extractor, create an structure with the following fields: amort_plan, us_rate,ne_rate,se_rate,nc_rate,sw_rate,w_rate, us_points, ne_points, etc. Assign examples to this structure. As the margin fields are not always available, I recommend you to set an example of each case; with and without margin. 3.- Iterate both extractors and add the results to a Record Constructor. Hope this can be helpful!
Denodo Team
13-07-2015 06:26:53 -0400
code
1. I have a corporate license that covers ITPilot as well 2. Thanks for the suggestion. I have created the suggested extractors but I have failed to connect them to the single Sequence in the process. Do I have to re-create Sequences for each of the Extractors in the same process? Again thanks for your assistance.
user
13-07-2015 10:22:21 -0400
Hi! You don't need to re-create the Sequence just use the same sequence as Input for both extractors and both of them will be able to extract information from the same Sequence.
Denodo Team
13-07-2015 11:03:11 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here