Data refresh in analysis after join

New column added after full join is appearing at the joined dataset level but data not refreshed in analysis. It is coming null. I have similar joins with other excel and it is working fine. Thanks!

Hi @vinj - Can you please validate the data set page whether the new column is available or not. Or else you may need to recreate the data set again. First check the data set page whether new column is available or not.

Regards - Sanjeeb

New Columns are available in the dataset after the join

Hi @vinj - In that case you need save and publish so that this can be use and available in your analysis.

Regards - Sanjeeb

1 Like

Hi @vinj - Are you pulling data from a static file? Like excel or CSV? You may have to re-upload/recreate the join for the data to show.

Check here Excel data soruce refresh

2 Likes

Yes joining excel static file with a standard dataset to create a new one

1 Like

Okay so it may be that the data is stale. Let me know if the solution from the other question helped.

2 Likes

Hi @vinj - Is your problem resolved after uploading the file again?

Regards - Sanjeeb

1 Like

No Sanjib. We deleted and added file again , did a full join. It appeared once but the same problem resurfaced. No data for these new fields, rest is working fine

1 Like

Hi @vinj - No problem. To investigate the issue in detail, can you please raise a ticket to AWS Customer support team so that they can investigate the issue with screenshare. This way the issue will be resolved quickly. To raise the request, please follow the link - Creating support cases and case management - AWS Support

Regards - Sanjeeb

1 Like