Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
MVP
MVP
‎2022-01-12 12:02 AM

How to load data from tables pre-defined in excel template

Hi All,

Can any one provide me a script for extraction with data dictionary , data will be taken from excel template with table names & list of fields to be loaded along with incremental load.

Thanks in advance 

Vikas

 

 

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Labels (1)
Labels
372 Views
0 Likes
2 Replies
Pillow410
Contributor
Contributor
‎2022-01-12 12:13 AM

In Excel, select Data > Queries & Connections, and then select the Queries tab. In the list of queries, locate the query, right click the query, and then select Load To. The Import Data dialog box appears. Decide how you want to import the data, and then select OK.

skylight paycards

339 Views
0 Likes
vikasmahajan
MVP
MVP
‎2022-01-12 09:03 AM
Author

In response to Pillow410

Hi Pillow410,

Thanks for your reply I am looking for solution like  i will define my tables & columns in excel template & wanted to fetch those table & columns from SQL.

 

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
264 Views
0 Likes