This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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.
Change logic from "Contains" to "Regex_Match"
Another work-around could remove the characters, but it also removes your Chinese characters.
I will forward this thread to email@example.com for their attention.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.