CUDOS dashboard, Join different datasets

Question & Answer
, , , ,
1

Hi,
I have both CUDOS and SCAD dashboards, each using a different dataset. In the summary_view, I added a new column with a string type (e.g., column name: TestA). I used the following expression:

, CAST('' AS varchar) AS TestA

After that, I created a join in QuickSight between summary_view and scad_cca_hourly_resource_view.
Join type: Left join, using TestA <- Namespaces.

When I try to add the TestA field to the analysis dashboard, the field value appears empty.

any idea, how can I join correctly?

2

Hello @Zaza , welcome to the QuickSight community!

I believe the issue here is that you are joining on an empty string for TestA. What are you trying to join on or what is your end goal with joining the datasets?

Are you trying to bring in rows based on Namespace? If so my bet it came back with nothing because its unlikely that the Namespace field would have empty values.