Saving one table as Linked to Source and other as embedded.

[barry pegado]

Hi All,

I have a Analysis which has 2 data table.On which i have created a Automation job which includes 2 task:

1.Open Analysis from Library.

2.Save Analysis to Library.

While saving analysis to library it has a option to embed data in analysis. I would like to embed only one of the data tables and not both.

Any idea how i can acheive this

Thanks

[Sean Riley]

Open the report and go to:

 

Edit > Data Table Properties

 

For table 1 > General Tab > Store data > Linked to source

For table 2 > General Tab > Store data > Embedded in analysis

 

 

 

Then when saving the report, dont choose the option to embed/store all data. That way table 1 will be loaded live and table 2 will just use the embedded data.

[Michaelino Mervisiano]

What if I have two data that I want append 1. Data 2018 is Embedded (as no change) 2. Data 2019 is Live (It changes every week) What should I do As when I insert row, the data got into one data table