Working on macro for automation

Question

Hello There,

I am working in alteryx desktop and creating a macro for automation. My issue is that i use odbc data input and it got my table or query select.... and i am asking you if you can help me to extract this select query without using RegEx or a new input.

Thanks a lot,

Best Regards.

Dark_Star9 · Accepted Answer

Hi @OllieClarke I just had to put a field info linked to my dataset then cross tab to extract the metadata that contains the sql query.

All is resolved thanks for your reply !