ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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

csh8428
8 - Asteroid

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

Jonathan-Sherman
15 - Aurora
15 - Aurora

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

csh8428
8 - Asteroid

I know that makes it difficult.. Sorry!

I added 1 sample row to the OP.

Maskell_Rascal
11 - Bolide

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. 

 

Maskell_Rascal_0-1617905011968.png

 

Thanks!

Phil

csh8428
8 - Asteroid

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
11 - Bolide

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. 

 

Maskell_Rascal_0-1617907367160.png

 

Thanks!

Phil

Labels