Formula tool says 2 values are different, but excel and the Crew Delta say they're same

Question

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

Maskell_Rascal · Answer

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

csh8428 · Answer

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?

Maskell_Rascal · Answer

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