You can translate the question and the replies:

Tracing a view field to its original source and original field name

Hi, Is it possible to query a view and get the original field name of the field name in the view? For example, if I had a view of CustomerPurchases and the field was CustomerFirstName but the original source the view pulls from is called Customers360 and the field name the view maps to is called FirstName, is there a way to get the name of the source and the field name via VQL?
user
24-01-2022 14:33:13 -0500
code

1 Answer

Hi, You can retrieve the original view name and column names by executing the COLUMN_DEPENDENCIES() through VQL, refer [COLUMN_DEPENDENCIES](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/column_dependencies) article. I would refer to the answer provided in similar Community Q&A for additional reference [Getting interface view column names from reference table](https://community.denodo.com/answers/question/details?questionId=9064u000000HAaNAAW&title=Getting+interface+view+column+names+from+reference+table) You can also obtain the same information using [Data Lineage](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/data_lineage/data_lineage#data-lineage) in the Virtual DataPort Administration Tool with administrative privileges. Hope this helps!
Denodo Team
 Edited on: 25-01-2022 02:40:00 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here