Inforiver Matrix provides the flexibility to input values in Excel and seamlessly import them into the visual.
Using the import utility is as simple as selecting the Data Input measure to input values for -> downloading the Excel template -> entering values directly in Excel, and importing the template back into the Inforiver Matrix visual.
Let's look at the steps involved and the options Inforiver Matrix provides to import data from Excel.
STEP 1: In the Data import utility pop-up window, use the Choose Measure dropdown to select the data input measure for which we are importing data. We can import data for one measure at a time.
STEP 2: If you've already entered values in the data input field, you can choose the 'Template with existing values' option to capture the existing values in the template file. Choose 'Blank template' if you do not need the existing values in the template file.
Click Download.
STEP 3: Enter values in the downloaded file. In this case, the values already entered in the report have been captured in the template file. Let's add values for the Central and East regions.
STEP 4: Click the Next button after entering data in the downloaded template file.
STEP 5: Click the Browse button. Select the template file that contains the new data input values to be imported into the visual.
STEP 6: Select the Ignore null or blank values in the CSV checkbox if you do not want to import null values from the template file.
Click Apply.
You'll see that the values we entered for the Central and East regions have been imported into the visual.
