Page Comparison

By the end of this chapter you will be able to:

...

In 2 Using Excel Templates, you downloaded train.zip and saved the files to <path>. Find this file: <path>\inputData\AccountTransactions\AccountTransactions.xlsx. The second tab of this workbook – accountHistory contains details of account transactions.  

...

1. Create a new model called Read Account History.


   Expand
   title How?
   In the repository browser, right-click Analysis Models then click  Insert excerpt _add_object _add_object nopanel true  Analysis Model. PhixFlow displays the empty model in the modelling pane on the left and opens the model settings tab on the right. In Basic Settings →  Name, enter Read Account History.

   


2. Add a file collector and set Basic Settings → Name: LoadAccountHistory.

   Expand
   title How?
   From the model toolbar, drag  Insert excerpt _add_file_collector_add _file_collector nopanel true  into the model. PhixFlow displays the settings tab for the new file collector.

   
   

3. In the settings tab toolbar, click 

   Insert excerpt
   _save _save nopanel true

   .

4. Upload the data.

   Expand
   title How?
   In the model, hover your mouse pointer over the AccountHistory file collector to display the context toolbar and click  Insert excerpt _upload_file _upload_file nopanel true .  Navigate to the directory <path>\train\inputData\AccountTransactions\AccountTransactions.xlsx. Select the file AccountTransactions.xlsx and click Open, then click Insert excerpt _upload_button _upload_button nopanel true .

   
   

5. PhixFlow adds a new stream to the model, called LoadAccountHistory.

...