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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to insert the same row into different DB tables that have the same structure but different names / database name

Hello,

 

I guess this should be easily done but all my tests failed so far !

I have to same data in different tables having the same structure. I have this scenario :


-  tables belongs to the same database but do have different tablename
or
-  tables belongs to different databases but have the same tablename.

 

Today I'm putting all DBInput in a daisy row.

 

0683p000009MZhT.pngDBInput in daisy row

This worked a bit but I'm getting today a java execption telling me that my mainmethod cannot exceed 65435 char....

Is this possible to adapt this and iterating through a list of tablename / database name and modify the tDBInput.tableName or tDBINput.databaseName property with java code on each iteration through the list?

 

Thank you for your help.

 

Regards

 

Stéphane

Labels (3)
0 Replies