We have Alteryx in our organisation, can I use Alteryx tool for ETL automation testing

[sowmya1301]

We have Alteryx in our organisation, can I use Alteryx tool for ETL automation testing?

[alexnajm]

Can you give any more specifics? Yes Alteryx can be used as an ETL tool

[jdminton]

Yes! I currently do this. You will need a license though if you don't have one yet. ;)

[sowmya1301]

We actually Extract, Load into data lake and then transform with the data warehouse.

For this as a QA, can I develop a framework Test cases in Alteryx to make our ELT testing more enhanced?

And we have licenses

[alexnajm]

Yes you can!

[apathetichell]

What's your end to end here - the short is "yes," but will it solve your problem - "maybe?"

[sowmya1301]

I need to do "Cross platform table comparison" and build a test suite with multilple test cases. if in this case can you please help me with the link so that I can refer how to do it.

This would be more apprieciated. Thanks a ton.

[alexnajm]

If you are comparing table to table I would look at the Expect Equal macro as part of the CreW macros: Chaos Reigns Within: Macros