topic Re: How do Straight table data can export to csv or xls file automatically. ? in QlikView

How do Straight table data can export to csv or xls file automatically. ?

tulabandula — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am looking out for a solution to export the straight table data into .csv or .xls file everyday automatically in a folder given. Can anybody help me with code to export the chart data into desired file and folder with full of data(6 lak records).

Thanks in Advance...!

Re: How do Straight table data can export to csv or xls file automatically. ?

CarmenReilly — Fri, 27 Apr 2018 15:59:54 GMT

Hi Sreeni!

Is this QlikView or Qlik Sense?

-Carmen

Re: How do Straight table data can export to csv or xls file automatically. ?

eduardo_dimperio — Fri, 27 Apr 2018 16:50:56 GMT

QLIK SENSE

Store YourTable INTO [Your_Path.csv](txt)

This will export to CSV, Qlik Sense does not export automatically (yet) to xls

Re: How do Straight table data can export to csv or xls file automatically. ?

tulabandula — Fri, 27 Apr 2018 17:30:34 GMT

Hi Carmen,

Thank you for your reply..

I am wondering in qlikview as of now.

thanking you.

Sreeni

Re: How do Straight table data can export to csv or xls file automatically. ?

tulabandula — Fri, 27 Apr 2018 17:32:08 GMT

Hi Carmen,

requirement is in Qlikview.

Thanks in advance.

-Sreeni

Re: How do Straight table data can export to csv or xls file automatically. ?

adityaakshaya — Fri, 27 Apr 2018 17:56:29 GMT

Hi Sreeni,

There are two ways through which you can achieve this.

1. Using NPrinting, You can schedule your straight table export

2. Using the load script. Create a table same as Straight table(having the same dimensions and measures) in the script and you can store the table as below

Store <Your Table Name> into <YourFileName.csv>(txt)(delimiter is ','); Now whenever your application get refresh it will create a csv and save it to your desired location.

Hope this helps.

Regards

Re: How do Straight table data can export to csv or xls file automatically. ?

Anonymous — Fri, 04 May 2018 16:42:15 GMT

Hi Sreeni,

I've moved this post to the New to QlikView space for you, as it will get the most relevant responses there.

Best regards,

Qlik Community Team

Re: How do Straight table data can export to csv or xls file automatically. ?

tulabandula — Thu, 02 Aug 2018 13:26:33 GMT

Hi Aditya,

Thank you for giving couple of options but tedious for small accounts..

Need to download 10 reports so i would have resident 10 times with respective field to store specific report dimensions for Storing in to .CSV hence can i have a macro script type of solution where Chart Object(CH01) can download and send over an email to user Without installing N Printing..

Regards,

Sreeni.

Re: How do Straight table data can export to csv or xls file automatically. ?

adityaakshaya — Mon, 27 Aug 2018 21:46:52 GMT

Hi Sreeni,

Sorry for replying late.

Yes you can use Macro for exporting but macro will not work on Qlik server and also not suggested by Qlik.

Regards,

Akshaya

Re: How do Straight table data can export to csv or xls file automatically. ?

tulabandula — Wed, 29 Aug 2018 11:59:37 GMT

Thank you Akshaya Aditya.