How-To Guide: Different Sheets

Scenario 3

Import excel workbook with multiple worksheets, each sheet containing data sets Or formats from different companies. To update this Excel workbook into Remote tables

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 WorkBook).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 -

34KB

Cash Schedule - (Excel WorkBook).xlsx

_______________________________________________________________________________________________________

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