MSCEWI2083
Not able to transform two or more complex Select clauses at a time
Last updated
Not able to transform two or more complex Select clauses at a time
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Medium
SnowConvert is not able to transform two or more complex SELECT clauses, as it is necessary to map them to a CTE or composite FROM clause, which causes the mapped code to not compile or enter into a logical cycle.
Those that required to be mapped to a CTE or composite FROM clause such as NORMALIZE, EXPAND ON, or RESET WHEN.
The transformation of the EXPAND ON clause is performed however the NORMALIZE clause is commented on due to the explanation above.
If you need more support, you can email us at