Page Comparison

...

• Create a new model Read Account History
• Drag - Add a new File Collector onto the modelling pane menu
• Call the new file collector Read Account History
• Hover over your new File Collector, and press
• In the file explorer, go to: …\inputData\AccountTransactions
• Select the file AccountTransactions.xlsx and press Open
• In the Upload Managed File form, press press Image Modified

By default the file collector is set up to read from the first sheet in the workbook – and the Stream is configured to hold this data.
You will need to update this configuration to read from the second sheet:

• Permanently delete the generated Stream ReadAccountHistory
• Open the configuration form for the file collector by double-clicking the icon on your modelling pane
• Go to the Advanced tab
• In the field Excel Data Expression enter: "accountHistory!A1:F100"
• Press Press Image Modified - Apply
• Go to the File Columns tab
• Delete the attributes that have been automatically created (these reflect the data in the first sheet in the workbook)
• Move to the File Columns tab
  • Press - Create the file attributes automatically from the header row in the file

...