Change Table Name

Vikas Bhorhari shared this question 7 days ago
Answered

In View, table "A" rename to "B".(No Changes in column number and column name.)

As per YF functionality

If we want to use table "B" in view, first remove table "A" and drag & drop table "B".

In this scenario, Columns and table joins associated with table "A" are dropped.

Again we have to do same activities with table "B".

Is there any functionality to rename the table without any impact.

Comments (5)

photo
1

Hi Vikas,

Thank you for reaching out to us.

Changing the name of a table within Yellowfin shouldn't have an impact. I have attempted to create your scenario locally and the following happened.

  1. Created a view with Tables "A" and "C", joined this tables together and selected all fields.
  2. Change the name of table "A" to "B"
  3. Drag and Drop table "B", the system recognizes that there is already a table "B" and creates this table as "B 1".
  4. Now I have a view where "B" and "C" are joined correctly and "B 1" is available.

Please let me know if you have experienced a different behavior or if I have misunderstood your question.

Kind regards,

Nathan Goddard

photo
1

Table Rename in Database level not YF View level.

photo
1

Hi Vikas,

Thank you for getting back to me and confirming the detail.

If a table exists in a view and that table is renamed in the database you will see that when you edit the view that table will be shown in red. You can see this in the below screenshot where I have changed the name of my table from "mock_data" to "mock_data_2".

/624d66dd9a1a7404a1a73fa7dc911ea1

Clicking on rename will allow you to correct the name of the table as it is now

/999056bb1c855c123b4397db9eebf9f8

Updating the name here to the new table name in the database. Once this validates the field will return to the color blue.

/3a1b2570c0a1f8600e5290f997e65c07

I hope this helps, please let me know if you have any questions.

Kind regards,

Nathan Goddard

photo
1

Thanks

photo
1

Hi Vikas,

You are very welcome.

Please could you let me know if you are happy for me to mark this question as answered?

Kind regards,

Nathan Goddard

photo
1

Solution worked for me.

Pls close the ticket

photo
1

Hi Vikas,

That is great to hear. Thank you for confirming.

This question has now been marked as answered.

Have a great weekend.

Kind regards,

Nathan Goddard

photo