Workflow incomplete message/error

Q&A
,
1

I am trying to create a simple workflow in quicksight to join two data sets and convert the datatype of a column from string to decimal. I keep getting the message/error that the workflow is incomplete and it doesn’t allow me to save/publish. Any ideas ?

2

Hello @rajasrc

Welcome to Quick Suite Community!!

I have just tried a similar workflow:
a) Added two simple tables
b) used a left join to join both the tables
c) Select few columns
d) Changed the data type from String to Decimal

Here, I had two observations:

  1. When a column(here String) is compatible with a the new Data Type (here Decimal) - then it saves successfully.
  2. When a column (here String) is not compatible with the new Data Type (here decimal) - It gives error like:
Cannot publish dataset
Workflow is incomplete.

I will recommend to review all the values under your String Column, there might be 1 or two entries which may not be supporting Decimal Conversion - hence it gives you this error.

While I see the error is misleading here. I can make a note and point out to our Product Team.

3

Actually, i have the same problem, i’ve checked there was no mismatch data types as your given example but still the same error message without any clue. In my case, i join orders with products (it’s ok) but when i add another join orders with stores then error

4

Hello @binhtq

Welcome to QuickSight Community!

Can you share a screenshot of your Data Prep page showing the Join Configuration please? I will try to replicate the same on my end and let you know the observation

5

I was able to fix my issue. it was not datatype issue but noticed if the workflow is not sequential, then this throws an error. i.e. you first do join then the datatype conversion or vice versa. Does quicksight not allow parallel processing in workflows ?

Summary

This text will be hidden

6

Hi @rajasrc,

Following up here as it’s been a while since last communication took place on this thread. To answer your latest question, QuickSight does allow parallel processing through a feature called Divergence. Refer to this link for more information (Advanced workflow capabilities - Amazon Quick Suite). Did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you