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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to insert into many DB tables at once?

Tags:
Hi all.
I have to read a file Excel and for each record, i need to write on many database tables.
I tried to use tFileInput and tDBOutput but i found i can write only on *one* table. How can i perform many operations for each row?
By the way, operations for a single row must be in a transaction: if something goes wrong, they have to rollback. Also this, i do not know how to do.
Someone may suggest me some hint?
Thank you
Labels (2)
11 Replies
Anonymous
Not applicable
Author

hi
I have a excel sheet as the input source and Mysql db tale as output, i can insert data from
excel sheet to table. but i want another thing to do, i want to add another new row for each
rows in the table
how can i do this
Anonymous
Not applicable
Author

Hello ishk
but i want another thing to do, i want to add another new row for each
rows in the table

Can give us example to explain your request? I will show you a job.
Best regards

shong