Derived Table name appearing different

[Former Member]

Hi All,

I have created a derived table with the name DT_Books in dev instance

but when I check its script in query panel the derived table name is  replaced by another name Table_4.

However in Prod instance I can see the same derived table with same definition and when i view the script in query panel the derived table name is displaying appropriately as " DT Books"

Can anybody assist on this

Thanks,

Chaithra M.R

[amitrathi239 · Accepted solution]

is there double quotes in the Derived table name? if yes remove double quotes from the name and try.

universe is built via UDT or IDT?

[Former Member · Accepted solution]

I have not used Double Quotes in the  Derived table name .

Universe is built in IDT

[amitrathi239 · Accepted solution]

right click on the table->Delimit->select either No (tables and columns) or No (Table Only).

[Former Member · Accepted solution]

Hi Amit,

Thanks a ton this is working fine.

Can you please let me know what exactly the delimit option does when we opt for "No Table Only"? or No (Tables and Columns)

Thanks,

Niki

[amitrathi239 · Accepted solution]

Delimit "No Table Only" will remove the double quotes from the table name.it mean you will not get the Table_1 which is table Alias.

if your query is like

Select

Table_1.Object1

Table_1.Object2

from

table name as Table_1

it means double quotes are around columns & table name.in that case use delimit No (Tables and Columns) option to remove the alias.