# Qlik

## Export data to Qlik

Acho supports connecting to Qlik via API. Follow the steps below to export data to Qlik.

1\. In **Data Prep**, click the export button on the top right of the table. 

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FR3csO7z5TpjG6ONV3AEA%2Fimage.png?alt=media\&token=a9f70a98-d227-477a-8ab9-cdc880db18bc)

2\. Select **Qlik** and click **Export to Workflow**.

<figure><img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FYrXfXSb8ykbhGek1K8hu%2Fimage.png?alt=media&#x26;token=22ec38da-9de5-41f4-b590-03daf64fb7e1" alt=""><figcaption></figcaption></figure>

3\. In Workflow, drag **Qlik** from the right sidebar to the canvas. Then, **link it** to the table that you want to export by dragging connection between the table and destination.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FnjvX7589pJloeDqKxMFM%2Fimage.png?alt=media\&token=56607480-7f63-41ee-97b1-c0747d88066a)

4\. Acho generates an API link for your table automatically. Then, copy the link.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FNsltgFUDL2WjOnqy0Tc7%2Fimage.png?alt=media\&token=0cd405d5-01a6-447b-9d25-f9defc4816bc)

5\. Open your **Qlik** and navigate to **Add new** **> Connect to data.**

<figure><img src="https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FBPgZoWYnPEEeu6T2WRrw%2Fqilk.png?alt=media&#x26;token=8a7c0519-8db7-42c2-af77-cdd98524d7a9" alt=""><figcaption></figcaption></figure>

6\. Find the **REST API connector**.&#x20;

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FwGtQr9iPGrFif7TDmVkP%2Fimage.png?alt=media\&token=5e5cc9a0-70dd-42f4-b538-2078e5280325)

7\. Paste the API that you just generated in the URL field and remember to rename the data connection (by default, the name is the API URL but it may cause the failure to create the connection). Then, click **Create and analyze**.&#x20;

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FaaPzOj50L0hclf3ATjRk%2Fimage.png?alt=media\&token=8b1112af-ad7e-4700-b57a-864eeb4c9d09)

8\. Once your Qlik connects to Acho successfully, you can check **CSV\_source** to preview your data and remember to select **CSV has header**. Click the **Next** button to continue.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2F9oAHif0ZGNihbQyfp4vU%2Fimage.png?alt=media\&token=16146877-21eb-49cf-9ac3-7dc8ab9e737d)

4\. It may take a few seconds to import data depending on your table size. When your data is ready, a CSV\_source circle will appear in the window. &#x20;

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FDBHbZVXYZYiXGhbyc8Vl%2Fimage.png?alt=media\&token=19849052-50fa-49c8-8583-d851623ac5dc)

5\. If your table on Acho is changed or updated, you can click the refresh button below the table to retrieve data again.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2F2G4oLg0YJPZ7xaWpG6aE%2Fimage.png?alt=media\&token=23cd25b6-dfa1-4542-90c4-08a7cce24984)