How-To Guide: Multiple Sheet

Scenario 2

Import excel workbook with multiple worksheets, each sheet containing data from different companies, - collected as part of data collection activity.

To update this Excel workbook into Remote tables

Refer to the User's excel files for reference we will use for this Scenario -

Scenario Flow : Visual dataflow diagram for this scenario for representation purposes

Step1 - Create Remote Tables

Follow same steps as for Scenario1, Attaching the Connection file for reference

75KB

Connection File Schema (By Worksheet).xlsx

Step2 - Upload excel files

Follow same steps for achieving this Step as Scenario1.

Attaching the User's excel file for Import for this Scenario -

32KB

Cash Schedule (Multiple Worksheets).xlsx

Multiple Excel files Can also uploaded, as long the configuration is same in this Scenario

_______________________________________________________________________________________________________

Authorization

Note that the Remote Tables Import follows the role authorization set for the user.

Only the users who have access to the respective Instance field values, as defined in the Instance Details connection schema will be able to Import/upload the data

example - in the above scenario COMPANY, if users have access to 1010 Only , JustPerform will not upload data for 1030

Update by default , the Re-Import will always REPLACE data based on Instance