cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Resolve ambigous field names in Datasphere SQL View

_Toni_
Explorer
0 Kudos
281

Hey Experts,

when joining different Views in Datasphere via graphical view the system automatically deactivates the same named fields which are available in both views. 

When building the sql view as far i know we don`t get the feature of automatically handling  this and I´m curious if anyone has a clue how to effectively resolve this issue. 

My approach was to copy the field list and let a short script run over it to detect duplicate field names and handle them with alias prefix or delete them directly from the output list. 

As this requires a manual step outside of Datasphere I´d like to know if anyone has a better way to do this or if I missed a built in functionality here?

Regards

Toni

Accepted Solutions (0)

Answers (0)