Skip to main content
Submitted

Prefix all fields of a table

  • March 5, 2020
  • 4 replies
  • 1 view

Forum|alt.badge.img

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.

4 replies

Forum|alt.badge.img
  • Known Participant
  • 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?


Forum|alt.badge.img
  • Author
  • New Participant
  • 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.


Forum|alt.badge.img
  • Known Participant
  • 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!

 


  • Participating Frequently
  • February 12, 2021

Thanks for your product feedback.

We have passed your input to our R&D department for further evaluation.

The roadmap of our product is focused on a split in ODX, MSW, Semantic Layer and Customer Portal.

With that split we will see new features and functions appear that might exceed your expectations or make the request obsolete.