Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
    titleHow?
    1. In the repository browser, right-click Analysis Models then click 
      Insert excerpt
      _add_object
      _add_object
      nopaneltrue
       Analysis Model.
    2. PhixFlow displays the empty model in the modelling pane on the left and opens the model settings tab on the right.
    3. In Basic Settings →  Name, enter Read Account History.


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

    Expand
    titleHow?
    1. From the model toolbar, drag 
      Insert excerpt
      _add_file_collector_add
      _file_collector
      nopaneltrue
       into the model.
    2. PhixFlow displays the settings tab for the new file collector.


  3. In the settings tab toolbar, click 

    Insert excerpt
    _save
    _save
    nopaneltrue
    .

  4. Upload the data.

    Expand
    titleHow?
    1. 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
      nopaneltrue
      .
    2.  Navigate to the directory <path>\train\inputData\AccountTransactions\AccountTransactions.xlsx.
    3. Select the file AccountTransactions.xlsx and click Open, then click
      Insert excerpt
      _upload_button
      _upload_button
      nopaneltrue
      .


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

...