Scripting in Database Views fields

[indrani Mu]

In cmn_location table ..i have buildings and sites..i.e a location can be either site or building ,we have parent field ..for each building site is parent ..in parent field site will be populated.

Now i want to export (buldings and sites) excel from location table with custom labels.

SiteName BuldingName SiteID SiteName

Though i am able to create a database view on location table and give custom labels ...but sitename and building name are referring same field which is name (location table)

unable to figure out how to create a field label referring to name

[Dr Atul G- LNG]

HI @indrani Mu 

Hope you are using the Plural different for both tables.

[BalaG]

Hello @indrani Mu  the column labels for the view you created can be changed by creating a new field label in sys_documentation table

1.  go to "System Definition" => Language File

2. create a new entry for the column / field you want to add a new label for

That's it. Here is an annotated example from my PDI

Hope that helps

--

Bala

Please mark this as helpful or a solution as appropriate.