Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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