Qlik Sense Straight table Lable funtions

[Qlikuser225]

Hello All,

Can you please let me know if there is any function for the labels field in Qlik Sense Straight Table.

For example, i have 20 tables with 100s of feilds like table 1 - AAA.Year,AAA.Month,AAA.Qtr etc

table 2 - BBB.Year,BBB,Month,BBB,Qtr etc so on

I want to know if there is any function where we can put in the label of straight to convert the names like AAA.Year to just Year  ; AAA.Month to Just Month and  BBB.Year to Year and BBB.Month to just Month and I can reuse the function for all the tables?

Thanks in Advance

[David_Friend]

@Qlikuser225 is there anything in this post that might help?

https://community.qlik.com/t5/QlikView-App-Dev/How-do-I-change-value-labels-in-a-dimension/td-p/1257...

[Qlikuser225]

Thanks for your reply,

I am actually looking for a function which i can use for all labels on straight table , my columns table 1 look like AAA.Year,AAA.Month,AAA.Qtr

and table 2 looks like BBB.Year,BBB,Month,BBB,Qtr and so on for table 3 etc

So instead on manually typing the label for each column like AAA.Year to just Year BBB.Year to just Year CCC.Year to just Year etc is there any function i can use to rename those columns? and i can reuse that function for all the columns in all the tables?

Thank You

Thanks

[NoahF]

No there is no built-in functionality to remove the prefixes only in the table.
You would have to either remove them in the script with a loop or something, but then you would get synthetic keys, which is why you probably named them like this in the first place.

However, there is a useful extension which has this functionality.

GitHub - ChristofSchwarz/qsQuickTableViewer: Qlik Sense Extension to quickly get all fields of a dat...

This extension is free and usually used to quickly load an entire table with all the fields with 2 clicks.
In the extension you can select to "hide prefix". After loading the table, you will have a normal straight table object.

It's easy to install and I feel like it's what you're looking for.

Regards