Official Support Articles

[Lasse123]

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

This example explains how to convert a Google Sheets file to a QVD in Qlik Cloud using a Qlik Application Automation.

NOTE: This solution only applies for files up to approximately 5MB and only for creating new files, not updating files.

Steps to convert to a QVD file:

1. Create a new automation in Qlik Cloud and name the automation, for example Inline load to generate QVD.
2. Add a Get Data From Sheets With Headers block from the Google Sheets connector.
   
   
   
   
3. Create a connection to Google Sheets under the Connection tab.
   
   
   
   
4. Add a list variable named csvitems
   
   

     

5. Add items to csvitems with the Implode function.
   
   
   
   
   
6. Where implode converts this list into a CSV:
   
   
7. Save the column headers in a new string variable named headers:
   
   

    

8. Add the first line, that is the headers, to variable headers. The implode formula converts the list of header items into a text separated with commas.
   
   
   
   
9. Separate the headers with a comma.
   
   
   
   
10. Add a loop block and loop through the Google Sheet and add items to csvitems.
    
    
    
    
11. Add items to the variable csvitems. The csv function converts the list to a CSV file.
    
    

      
    
    

12. Separate the values with a comma.
    
    
    
    
13. Add a string variable named loadScript.
    
    

    
     

14. Add values to loadScript variable:
    1. Apply Implode to convert csvitems to a list separated by linebreaks.
    2. Use Load*inline to load data. Note that the data is enclosed by square brackets [] and a semicolon (;) after the last square bracket.
    3. Store the result in 'lib://DataFiles/Testfile5.qvd'(qvd).
       
       
       
       
       
15. Create a temporary app with the Create App block from the Qlik Cloud Services connector.
    
    
    
    
16. Since the app will be deleted at the end of the automation, the naming is not important.
    
    
    
    
17. Load the loadScript variable into the temporary app with the Set Load Script block from the Qlik Cloud Services connector.
    
    
    
    
18. Configure the Set Load Script block with the ID attribute from the output from the previous block.
    
    
    
    
19. Save the app with the Save App block from Qlik Cloud Services, then all objects and data in the app are saved.
    
    
    
    
20. Configure the block with same app ID as in the previous block.
    
    
    
    
21. Then reload with the Do Reload block.
    
    

     

22. Configure with the same app ID once again.
    
    
    
23. Delete the temporary app with the Delete App block.
    
    
    
    
24. Configure with the same app ID.
25. Run the automation. If you look in your Qlik Cloud tenant you will see the app appear and then disappear once the QVD file is created.
    
    

Limitations

There are two important limitations to this method:

1. It only works for small data sets, up to approximately 5MB.
2. It only works for creating new QVD files, it is not possible to use it to update an already existing QVD file.

Environment

Qlik Cloud
Qlik Application Automation