Working on macro for automation

[Antoine-Vauthier]

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.

[OllieClarke]

Hi @Antoine-Vauthier I don't understand what you're trying to do here. Could you perhaps give us some screenshots explaining what you're after?

[Antoine-Vauthier · Accepted solution]

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 !