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.
PLEASE IGNORE THIS: Solution - I'm an idiot and forgot to change the old data-set from the "test" table to the "production" table. So there were indeed differences, but because of the truncations they weren't displayed.
I have a data-set(that I can't upload due to confidential data) with 2 columns(Hist and New). I then have a simple formula that compares the 2 to say if they're different or not:
Excel says they are the exact same. The Crew Delta Macro also says they are the exact same. As of right now, the values in "New" and "Hist" are the same, BUT For EVERY row, the formula is resulting in "Diff" when the result should be "Same"
Both columns are V_WString with length of 2048
The strings are somewhat long(less than 1,000 characters) as they are are concatenation of a bunch of other fields.
Can anyone thing of why the formula wouldn't be working?
Can you provide the sample data in a .yxdb file? When you copy and pasted your examples, it cut off everything after 212 characters. Running the samples provided in Alteryx shows no issue, so I'm guessing the problem is further down.
So, I think that 212 characters truncation is the issue. There is a Crosstab tool right before the formula tool. It is set to concatenate, and the Field Size is set to 7000. How can I make it so that the Cross Tab tool isn't concatenating?
If you are using Cross Tabs to concatenate, you can set the Field Size within that tool. Just increase it to the max amount (see picture below). This will solve your problem if the issue is being thrown by a difference in field size.