Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

AMP Engine / Classic engine - Does amp require explicit conversion for join?

d1miller99
7 - Meteor

Hi, I notice that if I have AMP unchecked, that the classic engine seems to implicitly convert. For example, I have one value that is "003450" and another that is "3450". With AMP unchecked, there is a match and a join. If AMP is checked, then we no longer have a join and there is no match. 

 

In addition, If we change the data type to "FIXED" from a string, wouldn't any leading zero be removed in the first place because this is not happening

 

 

5 REPLIES 5
gabrielvilella
14 - Magnetar

You are correct, the Fixed Decimal type do not remove leading zeros. Int and Double do remove. If you join on a fixed decimal and one has leading zeros, it will work on the original engine, but not on AMP. Alteryx might want to change this in the future.

TonyaS
Alteryx
Alteryx

Hi @d1miller99 

 

There are some differences with how AMP handles joins compared to original Engine. 

 

Some of that is documented , but I will look at getting this difference added to our documentation. 

 

AMP does not do any implicit conversion and does a strict join, which is why AMP will not join floats to doubles, int to doubles and so on.

Did you receive any kind of warning or error when using AMP? 

It would be helpful to get more details or a sample workflow to show what your specific use case is. 

 

Here are some links to our AMP related documentation, the 2nd link is to the differences between original Engine and AMP explained: 

 

•Help Documentation

https://help.alteryx.com/current/designer/alteryx-amp-engine

https://help.alteryx.com/current/designer/Alteryx-Engine-and-AMP-Main-Differences

https://help.alteryx.com/current/designer/AMP-Memory-Use

https://help.alteryx.com/current/designer/tool-use-amp

https://help.alteryx.com/20221/designer/engine-compatibility-mode

https://help.alteryx.com/20221/designer/performance-profiling-amp-engine

https://help.alteryx.com/20221/server/amp-engine-best-practices

 

•AMP Engine Webinar (32 minutes)

https://community.alteryx.com/t5/Analytics/AMP-Engine-Discover-the-Untapped-Performance-of-Your-Anal...

 

•AlterEverything Podcast

https://community.alteryx.com/t5/Alter-Everything-Podcast/66-The-Alteryx-AMP-Engine-Explained/ba-p/5...

 

•Community Blog posts

https://community.alteryx.com/t5/Analytics/Accelerate-Your-Analytic-Processes-with-the-New-AMP-Engin...

https://community.alteryx.com/t5/Engine-Works/AMPlify-your-Workflows/ba-p/617590

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Best-practice-with-the-new-Multi-threa...

https://community.alteryx.com/t5/Engine-Works/AMP-Engine-Technical-Deep-Dive-Part-1-Why-AMP/ba-p/570...  

https://community.alteryx.com/t5/Engine-Works/AMP-Engine-Technical-Deep-Dive-Part-2-Key-concepts-of-...  

Tonya Smith
Sr. Product Manager, cloud App Builder
d1miller99
7 - Meteor

Hi TonyaS

 

That answered my question perfectly! Thank you!

d1miller99
7 - Meteor

Oh one more question. Does anyone know if they will discontinue classic engine in the future and only use AMP. I read somewhere this would happen but wanted to make sure as I do not remember where I saw it. 

 

It seems it would be better to make sure everything is explicitly converted anyways, I notice when I do, it executes faster anyway. Even better with amp engine

TonyaS
Alteryx
Alteryx

There are no immediate or near-term plans to discontinue the original Engine. 

Official communications on any such plan would start far in advance and at this point it is likely multiple years out. 

Tonya Smith
Sr. Product Manager, cloud App Builder
Labels