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 ?
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:
- When a column(here String) is compatible with a the new Data Type (here Decimal) - then it saves successfully.
- 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.
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
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
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