Skip to main content
SUBMITTED

Prefix all fields of a table

  • March 5, 2020
  • 3 replies
  • 20 views

We prefer to add a prefix on every field of a table. This because when pushing data to Qlik, the fieldnames must be unique.
So on every field in a table we add (in most times) a logical prefix.
When having a table with a lot of columns this can be a lot of work to change it for every field.
A option to prefix every field of the table for once can be very useful in this case.

3 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • March 9, 2020

Does the "Enforce unique field names" option not already prefix the fields in the views generated for Semantic Models with the tablename?


  • March 9, 2020

@Rory: of course this can be a solution, but is depending on the way you work. We would like to change most of the fieldnames as soon as possible (most time this is in the DSA). In this case an easier prefix will be very useful.


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • March 9, 2020

As you are changing the name of all fields in a table, this is another use-case for: https://support.timextender.com/hc/en-us/community/posts/209086743-Multi-Select-capabilities

So add an upvote to that one as well!