Hi,
Is it possible to query sysobjects in alteryx e.g.
SELECT SCHEMA_NAME(schema_id)+'.'+name
AS SchemaTable
FROM sys.tables
save the results to a text file then
loop a select top 20 * from tablename (where tablename is on each row of the textfile) ?
Thanks
Dave
Solved! Go to Solution.
Hi,
You can run your first step via an Input Data tool.
To do the second, you will probably need a batch macro, and you will probably want to write this data out to files, to avoid having a large number of columns specific to each dataset.
Take a look at this article and see if it helps: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-...
Thanks 🙂