topic Re: New Field Added to Table. Does not Appear in SAS Viya. How do I add the field? in SAS Visual Analytics

New Field Added to Table. Does not Appear in SAS Viya. How do I add the field?

BarryP — Wed, 06 Jan 2021 22:40:15 GMT

Hi,

I'm using Release 8.5.1, SAS Viya release V.03.05

A new field was added to a table that I have in an existing dashboard, but when I go to the table under Data the new field does not appear.

If I create a new Dashboard and go to add the table, the field is there. However, I'm not certain that it is the same table. It has the same name, but it is entirely possible that I am looking in the wrong folder. I don't see anyway where I can verify which folder where the table in my existing dashboard.

I've tried refreshing the table, but it still does not appear.

So two questions:

1) How to I add the field to my existing dashboard.

- Note, I don't mean how do I go to the data panel and add it to a table in the dashboard. It does not exist in the data panel when editing the report.

2) How can I figure out what folder a table came from after the table has already been added to a dashboard?

Re: New Field Added to Table. Does not Appear in SAS Viya. How do I add the field?

AnandVyas — Thu, 07 Jan 2021 02:51:19 GMT

Hi @BarryP

I think table has to be reloaded to CAS with the changes for it to reflect.

Re: New Field Added to Table. Does not Appear in SAS Viya. How do I add the field?

BarryP — Thu, 07 Jan 2021 22:26:50 GMT

Okay, I have two copies of the table. One has a suffix .sashdat and the other with no suffix. The sashdat table has the columns I need. The other does not. When I tried to test this, I attempted to switch to the .sashdat (I didn't expect this to work) but it wouldn't let me use the table.

Re: New Field Added to Table. Does not Appear in SAS Viya. How do I add the field?

BarryP — Thu, 07 Jan 2021 22:44:17 GMT

Okay, I unloaded the table without the extension, and then loaded the one with the sashdat extension. Now they both have the columns I need.

I went back to the dashboard editor, it still isn't there. Maybe I need to wait until the DI jobs run?