If we have join/union in the dataset then do we have to refresh the main dataset every time after i do any changes in the child(Join/Union) dataset.
Smarten - Solution Team
started a topic
almost 3 years ago
If we have join/union in the dataset then do we have to refresh the main dataset every time after i do any changes in the child(Join/Union) dataset.
Best Answer
S
Smarten - Solution Team
said
almost 3 years ago
If you have done any join/union in the dataset then you do not have to refresh the main dataset every time after making changes in the child dataset.
If we have A, B and C dataset and ‘A’ is the main dataset in which ‘B’ & ‘C’ are joined.
If we do changes in any existing B or C dataset then it will reflect in main dataset ‘A’ only after saving the dataset B or C
It is not required to do refresh from source in the main dataset everytime after making changes in the child dataset. You just need to publish the ‘A’ main dataset to reflect those changes into the objects.
As per Below screenshot, we have added one new column in Demo_1 data set and Column name is City_new_column and this same column is reflecting in the main dataset.
Below is the main dataset’s screenshot. Here we have not refreshed the main dataset. It will automatically display that column in the main dataset.
Note: This answer is based on Smarten Version 5.0. This may or may not be relevant to the Smarten version you may be using.
1 Comment
Smarten - Solution Team
said
almost 3 years ago
Answer
If you have done any join/union in the dataset then you do not have to refresh the main dataset every time after making changes in the child dataset.
If we have A, B and C dataset and ‘A’ is the main dataset in which ‘B’ & ‘C’ are joined.
If we do changes in any existing B or C dataset then it will reflect in main dataset ‘A’ only after saving the dataset B or C
It is not required to do refresh from source in the main dataset everytime after making changes in the child dataset. You just need to publish the ‘A’ main dataset to reflect those changes into the objects.
As per Below screenshot, we have added one new column in Demo_1 data set and Column name is City_new_column and this same column is reflecting in the main dataset.
Below is the main dataset’s screenshot. Here we have not refreshed the main dataset. It will automatically display that column in the main dataset.
Note: This answer is based on Smarten Version 5.0. This may or may not be relevant to the Smarten version you may be using.
Smarten - Solution Team
If we have join/union in the dataset then do we have to refresh the main dataset every time after i do any changes in the child(Join/Union) dataset.
If you have done any join/union in the dataset then you do not have to refresh the main dataset every time after making changes in the child dataset.
If we have A, B and C dataset and ‘A’ is the main dataset in which ‘B’ & ‘C’ are joined.
If we do changes in any existing B or C dataset then it will reflect in main dataset ‘A’ only after saving the dataset B or C
It is not required to do refresh from source in the main dataset everytime after making changes in the child dataset. You just need to publish the ‘A’ main dataset to reflect those changes into the objects.
As per Below screenshot, we have added one new column in Demo_1 data set and Column name is City_new_column and this same column is reflecting in the main dataset.
Below is the main dataset’s screenshot. Here we have not refreshed the main dataset. It will automatically display that column in the main dataset.
Note: This answer is based on Smarten Version 5.0. This may or may not be relevant to the Smarten version you may be using.
Smarten - Solution Team
If you have done any join/union in the dataset then you do not have to refresh the main dataset every time after making changes in the child dataset.
If we have A, B and C dataset and ‘A’ is the main dataset in which ‘B’ & ‘C’ are joined.
If we do changes in any existing B or C dataset then it will reflect in main dataset ‘A’ only after saving the dataset B or C
It is not required to do refresh from source in the main dataset everytime after making changes in the child dataset. You just need to publish the ‘A’ main dataset to reflect those changes into the objects.
As per Below screenshot, we have added one new column in Demo_1 data set and Column name is City_new_column and this same column is reflecting in the main dataset.
Below is the main dataset’s screenshot. Here we have not refreshed the main dataset. It will automatically display that column in the main dataset.
Note: This answer is based on Smarten Version 5.0. This may or may not be relevant to the Smarten version you may be using.
-
How do I choose only required columns while creating a dataset with step by step wizard from any database
-
How do I select only the required columns after creating the dataset.
-
How to convert timestamp based text formats to Timestamp
-
I'm Unable to display graph with financial month values (that starts from April)
-
How can I merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year
-
How can I count day wise new addition of counts from the data with day wise closing balance of counts?
-
How can I apply rounding logic to time data – e.g. 1:39 PM should be 2 PM and 1:20 PM should be 1 PM.
-
Dataset Action Editor – Action item status (active or inactive) is not saved permanently
-
How can I create a dataset using stored procedures in RDBMS instead of a query?
See all 13 topics