Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

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

4 Replies
engishfaque
Valued Contributor III

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

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

vinod_nallapaneni
Contributor

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

Hi,

    Using Store command. (OR)

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

Vinod.

raajaswin
Contributor III

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

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

Highlighted
kalyanivintha1
Contributor II

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

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.