Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

insert multiple files using bulkexecute

I have a task where we need to retrieve the data from multiple tables and then store them to different database with similar structure.

 

So I have created a configuration table where all the required queries are written to pull the data and by iterating that i am able to create the delimited output files . I have used dynamic schema feature to handle the columns.

 

Now i want to insert those files to destination database using dynamic schema. But I am facing two Issues 

1. while passing the table name from the global variable it gives error that table doesn't exist . The root cause behind this is the table is enclosed with " ".

2. Not able to set the schema dynamically.

 

 

 

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hello,

To use bulk load you have to add fields definition into the bulk file or into an other file.

Best regards

Sabrina