I’m trying to add a forecasting dataset to my existing dataset so I can calculate difference vs OPx/R&O Goals. I’m trying to upload an excel dataset and full join it a Redshift dataset, but when I go through the process of matching the columns I get an error message and the data is unable to load. Has anyone ever had similar problems / gone through a similar excercise? If so, would love to know how you did it?
Something to note, my data set isn’t pivoted, so the values are in columns instead of the rows (Jan, Feb, Mar column vs One column for rev, and another column for the period.)
Hi @zachlond - Welcome to AWS QuickSight community and thanks for posting the questing. I believe you are facing the issue while doing the joining the data set between excel sheet and Redshift? Can you please see the sample data in the dataset option before doing the join and also is it possible to make redshift data set in SPICE?
Hi @zachlond,
It’s been awhile since we last heard from you. Are you still having issues with your original question or did Sanjeeb’s response help out?
If we do not hear back from you in 3 business days, I’ll go ahead and archive the topic. If you have any further questions past that though, feel free to create a new topic and link this page for relevant information.
Hi @zachlond,
Since we haven’t heard back from you, I’ll go ahead and archive this topic. However, if you have any further questions, feel free to create a new topic in the community and link this discussion for relevant information.