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

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

New script instructon : Alter Table on Qlik Sense (add column, set constraints with pattern matching, etc...)

simonaubert
Partner - Specialist II
Partner - Specialist II

New script instructon : Alter Table on Qlik Sense (add column, set constraints with pattern matching, etc...)

Hello,

As of today, if you want to add a column or change its format, you have to reload the full table (or make a join for add a column). You cannot also set a constraint on a field, wich can be very dangerous when you use join, concatenate or the next mere operator, having several format in a field or having to duplicate a check after each load.

Si the idea is to implement a new script instruction  : Alter table... similar to the SQL instruction
https://www.w3schools.com/sql/sql_alter.asp

also check
https://www.w3schools.com/sql/sql_constraints.asp

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
Tags (2)
4 Comments
melissa4
Contributor II
Contributor II

I would also like to use Alter Table in Qlik Sense script.

Patric_Nordstrom
Employee
Employee

Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea by commenting and liking.

Thanks, 

Patric

Status changed to: Open - Collecting Feedback
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Newbie
Newbie
 
Status changed to: Closed - Archived