Remove Variables from the Visualizer Type using the Excel Model

Overview

There are times when you need to remove duplicate values or hide certain variables from the prototype. It can be easily done using the Excel model.

Step-by-Step Guide

1. Follow the steps to Upload your Model/Create a Visualizer Type.

   

   
   

2. Click Save and then click Prototype and you can see all the values.

   

   
   

3. Open the Model and add a column titled Action.

   
   

4. Under the Action column, enter DELETE against the code references that you need to hide or delete.

   

   
   

5. Click Import Model via Excel.

   

   
   

6. Upload the edited model.

   
   

7. Ensure to click Yes from the Override Existing Blockly/Javascript drop-down list.

   
   

8. Click Upload.

   
   

9. Click Value Collaborator on the Visualizer Type page.

   
   

10. Click Save and then click Prototype.

    

    
    

11. You can see that the particular code reference has been removed from the Prototype page.

    
    

12. All the calculations done using the value of that variable gets nullified.

    

    
    

13. Click Export and then click Export Excel.

    

    
    
14. An Excel sheet gets downloaded to your device. Open the Excel document and you can see that the particular variable has been deleted.