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,
register vql
user
26-01-2023 08:38:39 -0500
code

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](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_flatten_views/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
code
You must sign in to add an answer. If you do not have an account, you can register here