Change Table Name

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

Table Rename in Database level not YF View level.

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".

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

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

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

Kind regards,

Nathan Goddard

Thanks

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