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

Open Studio - Defining Schema at Run Time.

I have a requirement to provide the schema at runtime and I realized that it's possible for a few scenarios and NOT for others. Let me explain:
When I attempt to TRUNCATE a table using the tPostgresqlRow component, I'm able to (as shown below).
0683p000009MDyM.png
However, when I use an existing connection to INSERT data into a table I get the following error: 

0683p000009MDyM.png
ERROR: relation "customer" does not exist
  Position: 13ERROR: relation "customer" does not exist
  Position: 13ERROR: relation "customer" does not exist
  Position: 13


I noticed an article on Talend -> "Can I define a schema at run time?" Is this why my INSERT doesn't work, while TRUNCATE works as I can specify the Schema Name?
What's the workaroud? The feature of being able to provide schema name at runtime will be a great way for me to get my work done.
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,
What does your schema look like? Unknown column structure that you have to define it at run time?

Best regards
Sabrina