...
- Create a new model with 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 Name to
Customer Care Updates
. - 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 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.
- PhixFlow displays a form for the new file collector. Set 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
. - Upload <path>\train\inputData\ChannelPackages\ShopUpdates\ShopUpdates.txt.
- PhixFlow loads 7 rows of data to this stream.
- Set the file collector Name to
Snapshot of the Channel Package Check
model so far:
Combine Data Sets
- Create a new stream in your model.
- Hover over
CustomerCareUpdates
and click Add a new Stream. - Set the Name to
Combined Updates
. - Drag all attributes from
CustomerCareUpdates
intoCombined Updates
.
- Hover over
- Save your model layout.
- Add a pipe from the other stream.
- Hover over
ShopUpdates
and click Add a new Connector. - Click
Combined Updates
to link the pipe to the output stream.
- Hover over
- Double-click on
Combined Updates
to open its configuration form and set the attribute expressions.
PhixFlow automatically adds a reference to the input pipe name at the start of each expression. To make the union work, you need to update the expression for each attribute to remove thein.
prefix. Changein.CustomerRef
toCustomerRef
. - Press in the main stream configuration form.
- 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.
...