Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

How to: use inline load to generate a QVD file in Qlik Application Automation

cancel
Showing results for 
Search instead for 
Did you mean: 
Lasse123
Employee
Employee

How to: use inline load to generate a QVD file in Qlik Application Automation

Attachments

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.

    Get_data_from_sheet_with_headers.png

  3. Create a connection to Google Sheets under the Connection tab.

    Create_a_connection_to_Google_Sheets.png

  4. Add a list variable named csvitems

      Add_Variable_csvitems.png

  5. Add items to csvitems with the Implode function.

    Add_Items_to_csv_variable.png


  6. Where implode converts this list into a CSV:

    Implode_add_to_csvitems.png
  7. Save the column headers in a new string variable named headers:

    New_variable_headers.png

  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.

    Configure_variable_headers.png

  9. Separate the headers with a comma.

    Edit_formula_headers.png

  10. Add a loop block and loop through the Google Sheet and add items to csvitems.

    Loop_through.png

  11. Add items to the variable csvitems. The csv function converts the list to a CSV file.

    Configure_csvitems.png

  12. Separate the values with a comma.

    Edit_formula_csvitems.png

  13. Add a string variable named loadScript.

    Add_string_variable_loadScript.png

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


      Add_values_to_loadScript.png

  15. Create a temporary app with the Create App block from the Qlik Cloud Services connector.

    Create_app.png

  16. Since the app will be deleted at the end of the automation, the naming is not important.

    Configure_Create_App.png

  17. Load the loadScript variable into the temporary app with the Set Load Script block from the Qlik Cloud Services connector.

    Set_Load_Script.png

  18. Configure the Set Load Script block with the ID attribute from the output from the previous block.

    Configure_Set_Load_Script.png

  19. Save the app with the Save App block from Qlik Cloud Services, then all objects and data in the app are saved.

    Save_app.png

  20. Configure the block with same app ID as in the previous block.

    Configure_Save_App.png

  21. Then reload with the Do Reload block.

    Do_Reload.png

  22. Configure with the same app ID once again.

    Do_reload_config.png
    Lasse123_2-1669192984168.png
  23. Delete the temporary app with the Delete App block.

    Delete_App.png

  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

Labels (2)
Version history
Last update:
‎2022-12-05 04:29 AM
Updated by: