Replace fields with new fields from another source

Dean Flinter shared this question 40 days ago
Answered

Hi,

We currently have some fields that are defined by a virtual table.

We've decided to add these fields to our main fact table instead for performance reasons. As such, the current fields will become defunct

The fields are used in lots of reports so manually editing them to replace the old with the new is not really feasible.

Is there a faster way to replace/swap/switch the fields so that the new ones propagate to all the reports?


Thanks

Dean

Comments (5)

photo
1

Hi Dean,

This might be possible with a View replacement import, as Yellowfin will try to match fields based on their name and data type for the column, if it can't be done with the UUID. If the names and data types match, it should replace the old fields with the new, despite them being 'different'.

Let me know if that works for you. Obviously replacing a view with another view carries some risk, so please take every precaution to ensure all data is backed up, etc.

Kind regards,

Chris

photo
1

Thanks Chris

I'll test it out on our dev environment.

Fingers crossed!


Thanks

Dean

photo
1

Hi Dean,

Hope you're well!

Just checking in with this one, did you get a chance to test?

Kind regards,

Chris

photo
1

Hi Chris,

Not yet unfortunately

The change I want to make is part of a wider update to our tables and I'm still working out some issues on that side

It could be a week or 2 before I do so if you want, you can close the ticket and if needs be, I'll post back to open it back up


Thanks

Dean

photo
1

Hi Dean,

No worries, I'll close this one off for now. Feel free to open it later!

Kind regards,

Chris