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

[d1miller99]

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

[gabrielvilella]

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 · Accepted solution]

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-...  

[d1miller99]

Hi TonyaS

That answered my question perfectly! Thank you!

[d1miller99]

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 · Accepted solution]

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.