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:
IF [New] != [Hist] THEN "Diff"
ELSE "Same"
ENDIF
I can provide 1 record for comparison
New:
BUILD-PART2,MAJORPROCESSAUDIT,NOTCANCELLED,COMPLETE,COMPLETE,NONE,Q3,2020,2020CARRYOVER,2020-08-17,2021-02-26,193,27.57,COMPLETE,2020-08-17,2020-09-04,2020-10-30,2021-01-08,2021-02-26,2021-03-16,N,Y,1,COMPLETE...
Hist
BUILD-PART2,MAJORPROCESSAUDIT,NOTCANCELLED,COMPLETE,COMPLETE,NONE,Q3,2020,2020CARRYOVER,2020-08-17,2021-02-26,193,27.57,COMPLETE,2020-08-17,2020-09-04,2020-10-30,2021-01-08,2021-02-26,2021-03-16,N,Y,1,COMPLETE...
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?
EDIT: added a sample
Hi @csh8428,
Can you give an example of two values which don't match? It's a little difficult to diagnose without some sample data. Perhaps try replicating it with anonymised data?
Kind regards,
Jonathan
I know that makes it difficult.. Sorry!
I added 1 sample row to the OP.
Hi @csh8428
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.
Thanks!
Phil
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.
Thanks!
Phil