Issue after removing joint table - visuals and calculated fields broken

Question & Answer
, , , , , , , , ,
1

Dear All,

I am facing frustrating issue and would really appreciate your guidance

scenario:

  1. I had a master table play in my data set
  2. I performed left joint from table B and table C to A
  3. Then also performed left joint from table D to table B
  4. Using this setup ,I created several visuals and calculated fields that referenced from table D
  5. lately I decided to table D from the dataset

Problem:
I started seeing this error :
field{{fieldname}} in {{expression}} does not exists

it appered that visuals and calculated fields using from table D are now broken and now unable to delete or fix them easily

what is the solution now to clean up my dataset
and visuals without breaking things further.

Please find the snapshot for the reference.

image
image1321×572 40.3 KB

Best,
Vaibhav Narwade.

2

Hi @Vaibhav.narwade

Since the issue is in the dataset have you tried reverting back to a previous version of the dataset?

Click on the Manage button the Edit Dataset page and click on Publishing History. There you should be able to select a prior version of the dataset.

image
image465×194 10.6 KB

Regards,
Giri

3

Hello @Giridhar.Prabhu,

I have tried this option but unable to publish the History.

Best,
Vaibhav Narwade.