topic Re: Hi All can any one tell me how can I store an excel or pdf that I viewed on QlikView in to oracle table? Thanks in advance for the help in QlikView

Hi All can any one tell me how can I store an excel or pdf that I viewed on QlikView in to oracle table? Thanks in advance for the help

Wed, 25 Nov 2020 16:16:04 GMT

Hi All can any one tell me how can I store an excel or pdf that I viewed on QlikView in to oracle table? Thanks in advance for the help

Re: Hi All can any one tell me how can I store an excel or pdf that I viewed on QlikView in to oracle table? Thanks in advance for the help

engishfaque — Thu, 29 Dec 2016 05:40:53 GMT

Dear Shilpa,

Here are the ways to export your data from QlikView to ".csv" or ".xls" file format.

1. Store .CSV file using Script: You can store data in ".csv" file format by using given below statement. Given below statement should be write in your script.

STORE YourTableName into myNewTable.csv (txt, delimiter is ',');

2. Send to Excel: This option can be enabled over the chart and you can export the data in a excel file format, Here is the way to enable the option

Right Click on Table Object > Properties... > Caption Tab > Special Icons > Checked to Check Box "Send to Excel" > Apply > OK

A little icon will appear upper right hand side with "XL" icon with tool tip "Send to Excel" just click on the icon and export your data in ".xls" file format.

Save As your excel file in your required location with appropriate name and load or performance action whatever you want (means you can load exported data into Oracle).

Kind regards,

Ishfaque Ahmed

Re: Hi All can any one tell me how can I store an excel or pdf that I viewed on QlikView in to oracle table? Thanks in advance for the help

vinod_nallapaneni — Thu, 29 Dec 2016 05:49:25 GMT

Hi,

Using Store command. (OR)

Right click on Object --> Export--> Excel, PDF

Vinod.

Re: Hi All can any one tell me how can I store an excel or pdf that I viewed on QlikView in to oracle table? Thanks in advance for the help

raajaswin — Thu, 29 Dec 2016 05:55:25 GMT

Probably, by using any ETL tools. informatica,datastage,ODi etc

Re: Hi All can any one tell me how can I store an excel or pdf that I viewed on QlikView in to oracle table? Thanks in advance for the help

Anonymous — Thu, 29 Dec 2016 06:44:00 GMT

Helo shilpa,

You can export your qlikview data into any other formats by using export option.

just right click on your table or object,

then click on epxort....

then you can get new window to export the data..in that...select save as type as execl or pdf or any thing you want like..csv file or txt file or html...etc.,

Thanq.