list top 20 * rows from all tables microsoft SQL database (high number of tables)

Question

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

Claje · Accepted Answer

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-Different-Field/ta-p/13370?advanced=false&collapse_discussion=true&filter=location&location=category:external&q=batch%20macro&search_type=thread

davidoc · Accepted Answer

Thanks 🙂