Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group

SQL Insert from QlikView.qvw

Partner
Partner

SQL Insert from QlikView.qvw

In this app I showed how to insert data into SQL Table by LOAD Script or using macro. Data from variables insert into SQL Table by this script:

INSERT INTO [dbo].[Table1]

           ([Param1]

           ,[Item1]

           ,[Item2])

     VALUES

           ('Listen', 'to', 'Skrillex')

For this task i used variables named like columns in my SQL Base.

Name of base: QlikViewBase

Variables: Param1, Item1, Item2

You can surely modify my creation and use it by your own purposes. Just say thanks to me and remember my name.

Tags (1)
Attachments
Comments
Partner
Partner

If you use macro select system access in its properties.

0 Likes
Partner
Partner

It's mind blast! QlikView is powerfull tool that can make everything.

0 Likes
Creator II
Creator II

Hello,

If I want to insert aprox. 120.000 rows, that FOR won't work well. Is there any other way to insert these values?

Not applicable

Thanks

0 Likes
Not applicable

Thanks Thanks!!

0 Likes
Not applicable

Did you by chance ever figure this out?  I've got the same problem where I have about 100,000 rows where the FOR loop is too slow.  Thanks.

0 Likes
Creator
Creator

Thanks

0 Likes
Partner
Partner

Well If there are lots of rows to insert we can use loop. It's complicated task but It can be solved. It'll be like portion insert.

0 Likes
Specialist
Specialist

You can make Qlikview write a file with the STORE command, and then call SQL BULK INSERT.


I know BULK INSERT is old technology, but it works very fast....


Robert

Creator
Creator

hi,

while reloding  data is inserting to sql  but macros is not working

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-04-18 04:53 AM
Updated by: