You can translate the question and the replies:

Query a field in a register in denodo

Hi, Can we query a subfield from a register in vql shell without knowing the exact path of the subfield. is there a query like : select [subfield name] from xxview. So if the subfield is under register1.register2..registerN, we dont have to specify the path.. Thank you,
26-01-2023 08:38:39 -0500

1 Answer

Hi, Generally, I flatten the register when I want to access the subfields. To flatten a register, create a Selection view and in the “Output” tab of the view, right-click on the register and click Project subfields of… For more details, you can refer to the [Creating Flatten Views]( section of the Virtual DataPort Administration Guide. If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
26-01-2023 15:58:03 -0500
You must sign in to add an answer. If you do not have an account, you can register here