Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
avigdova
Contributor II
Contributor II

Loading from HIVE to QVD file

Hi, the fields names in the qvd file are prefixed with the table name, for example:

the first field  name: tablea.control_id,
the second field  name: tablea.control_run_datetime

and so on.

how can i store the qvd file (or maybe load from the qvd) without the prefix, ie loadind only the fields names: control_id, control_run_datetime

its like subfield function but on the field name.

thank you

Labels (1)
2 Replies
vikasmahajan

Hi,

Did you try to unqualify fields refer following links for more details:

https://community.qlik.com/t5/QlikView-App-Dev/qualify-and-unqualify/td-p/262056

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

Vikas 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
avigdova
Contributor II
Contributor II
Author

Yes I did. Didn’t qualify it…