Not able to add additional filtering method (case when) to dataset

In this Aug EDW ASIN Selection datasets (which was created through custom SQL), we want to add a new column to be added - - “Case when asin in (select distinct asin from f3rbi.vw_mdl_instock_exclusion_asins) then ‘ExcludeUwiForCircularCheck’ else ‘IncludeUWIForCircularCheck’ end as UWIFlag” but the dataset doesn’t refresh/update properly.

I have tried in hubble and the query worked, however not in Quicksight. Our temporary solve is hardcoding the asins that we want to inlcude in the dataset, but this is not scalable as new ASINs will be added in to the table, and we want this reference to be dynamic.

Hello @seanc!

The community will not be ably to access you Quicksight via that link.

When you say that the dataset doesn’t refresh or update properly, does Quicksight provide an error message or any kind or are there problems with the resulting dataset?

Hello @seanc !

Are you still running into this issue and are you able to provide the error message that you received?

This is the error I have

Hello @seanc !

Thank you for posting the error message!

I believe that error is originating from Redshift. My main thought here is that it’s possibly something to do with an issue with data types of the key values during the joins.

Also, when you are trying to import this are you doing it via Spice or Direct query?

via SPICE. Is there any time i can set up with you to go over what we are trying and the issue we are running into?

can you post the query here?
Where is the data coming from, what type of database?

1 Like

Hello @seanc , sorry for the late reply I was OOO!

Are you able to post the query like @gillepa suggested?

Hello @seanc ! Are you able to share the query?

It’s been a few days since we have heard from you but we would still like to help find a solution. If we do not hear from you in 3 days this topic will be archived.