Documents for QlikView related information.
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]
('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.
If you use macro select system access in its properties.
It's mind blast! QlikView is powerfull tool that can make everything.
If I want to insert aprox. 120.000 rows, that FOR won't work well. Is there any other way to insert these values?
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.
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.
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....
while reloding data is inserting to sql but macros is not working