Alteryx 11 - PROBLEMS PROBLEMS PROBLEMS :-(

rmwillis1973

Hi,

Version 11 is now causing me a considerable headache!

1) The filter, which used to work perfectly, now is giving partial results. It selects some records, but not others.

Looking at the original Excel version i have, there are 96 records with the word "TEMPLATE", using a simple filter.

When i use Alteryx, i am only getting 14 records returned when i connect to the .YXDB version of the Excel file.

2) The Filter is creating a UTF error:

Filter (12) Invalid UTF-16 data: trailing surrogate that doesn't follow a leading surrogate

I have always had a mixture of alphanumeric characters within the Customer Name field, as well as foreign (e.g. Chinese) customer names. I've never had this problem before. I need to rely on the tool providing the a correct filter experience.

3) It has crashed about 10 times since launching Version 11. The previous version NEVER let me down. I was only trying to use the bottom slider to move around my module and it crashed on me.

Version 11 is rapidly becoming a very poor user experience!

Alteryx UTF error.docx

Workflow

Error Message

Preparation

Accepted answers

JessicaS

Hello,

Thanks for providing feedback on Version 11 performance.

We have released a patch today that is available for download(version 11.06) and contains updates that should help with crashing/freezing.

Please feel free to download at your convenience and send us an email at support@alteryx.com if you have any feedback or are still experiencing these issues.

Thanks!

All comments

MarqueeCrew

@rmwillis1973 (AKA Richard),

Here is a recap of our conversation/webex:

Research

yxdb data processed in a filter using Contains logic was ERRORING with a UTF-16 message, but produced partial results. What was created as an alternative version in Excel could run through the identical filter and work without issue.
yxdb data was transposed and compared to .xlsx data and data differences were discovered. The data included NULL values in Excel that appeared as "empty" values in the yxdb data. Also, data values existed in both sets with only minor format issues.

Resolution (work-arounds)

Change logic from "Contains" to "Regex_Match"

OLD LOGIC:

Contains([Company Name],"Template")

NEW LOGIC:

Regex_Match([Company Name],".*Template.*")

Another work-around could remove the characters, but it also removes your Chinese characters.

Regex_replace([Company Name],"[^\x00-\x7F]",'')

I will forward this thread to support@alteryx.com for their attention.

Cheers,

Mark

JessicaS

Hello,

Thanks for providing feedback on Version 11 performance.

We have released a patch today that is available for download(version 11.06) and contains updates that should help with crashing/freezing.

Please feel free to download at your convenience and send us an email at support@alteryx.com if you have any feedback or are still experiencing these issues.

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703