Transform and Cleanse does not recognize aliases that are done implicitly.
If using the Query Builder to create the query, the Query Builder will alias fields implicitly if you have more than one with the same name, but the Transform and Cleanse does not recognize these aliases, and so it returns the column ambiguously defined error.
