...
For this exercise you need two files from the zip file you downloaded in 2 Using Excel Templates, step 5. The files contain updates from the two sources: the customer care service and the shop.
- <path>\train\inputData\ChannelPackages\CustomerCareUpdates\CustomerCareUpdates.txt
- <path>\train\inputData\ChannelPackages\ShopUpdates\ShopUpdates.txt
- Create a new model with the Name
Channel Package Check
. - Add a file collector to your model and load the data.
- PhixFlow displays a form for the new file collector. Set the Name to
Customer Care Updates
.Navigate . - In the model, hover over the
Channel Package Check
file collector to display the context toolbar. - Click Upload Managed File.
- Navigate to the directory …<path>\train\inputData\ChannelPackages\CustomerCareUpdates.
- Select the file CustomerCareUpdates.txt and complete the automatic file collector and stream configuration.. and clickUpload.
- PhixFlow adds a new stream to the model, called
CustomerCareUpdates
. - In the model, hover over the new
CustomerCareUpdates
stream and click Run Analysis. - Check the data is loaded. There should be 8 lines of data, with columns for Customer Ref, Sales Date and Package.
- Now the data is loaded into the stream, set the stream to Static.
- PhixFlow displays a form for the new file collector. Set the Name to
- Add another file collector to your model and repeat the process described in step 2. This time:
- Set the file collector Name to
Shop Updates
. - Navigate to the directory …Upload <path>\train\inputData\ChannelPackages\ShopUpdates.Select the file \ShopUpdates.txt and complete the automatic file collector and stream configuration.
- Set the file collector Name to
- Run both streams and check that data from the files is loaded into each one.
- .
- PhixFlow loads 7 rows of data to this stream.
- Remember to set the steam to Static.
Snapshot of the Channel Package Check
model so far:
Combine Data Sets
- Create a new stream in your model and populate its attributes.
- Hover over
CustomerCareUpdates
and click Add a new Stream. - Set In the form, set the Name to
Combined Updates
.Drag - all attributes from
CustomerCareUpdates
intoCombined Updates
In the model, show the stream attributes forCustomerCareUpdates
. - Select all the attributes and drag them into the form for the
Combined Updates
stream. Drop them into the Attributes section.
- Hover over
- Save your model layout.
- Add a pipe from the other Connect the
ShopUpdates
stream to theCombined Updates
stream.- Hover over
ShopUpdates
and click Add a new Connector. Click
outputCombined Updates
to link the pipe to thestream.
Combined Updates
to open its configuration form and set the attribute expressions.Info When you connect streams, PhixFlow automatically adds a reference to the input pipe name
. this appears in the attribute expression. To merge this data successfully you must update the attribute expressions to remove the
in.
prefix
in.CustomerRef
toCustomerRef
.Press in the main stream configuration form.
- Hover over
- Fix all the attribute expressions.
- Double-click on
Combined Updates
to open its configuration form. For each attribute: - In the Attributes section, double-click on an attribute to open its form.
- In the form for the attribute, in the Basic Settings section, edit the Expression to remove
in.
and press .
- Double-click on
- In the
Combined Updates
stream form, press to save the changes. - Run analysis on
Combined Updates
. - Check that you have the correct number of records in this stream when the analysis is complete.Check the data set you generated to make sure that every field in every output record has been populated.stream has:
- the columns CustomerRef, Sales Date and Package
- 15 rows
- all cells have data.
The stream default view:
Snapshot of the Chanel Package Check model so far:
Record the Source for Each Update
...