I am feeding some data from an SQL table in Fabric into an Alteryx Flow, for some reason I get incorrect values returned when doing my queries in Alteryx with the OleDb driver. Extra characters are added at the end of the value that should have been returned.
Picture one (Sample ADS) shows what my query returns in Fabric or Azure Data Studio, and Picture two (Sample Alteryx) shows what the query returns in Alteryx with the OleDB driver.
My query is rather lengthy with quite a few CTEs, but CUSTOMER_1 value is defined as:
Case when gt.Dir = 'RET' THEN CONCAT(BDT,'_',CliMkt,'_RET')
ELSE CONCAT(BDT,'_',CliMkt) END AS CUSTOMER_1BDT is a string of 3 letters, CliMkt is a string of two letters.
I really don't see what could cause all these extra characters to be added in my return - What type of error makes this happen, and how is it prevented?
