community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Read some specific tables from access DB

Asteroid

Hi,

 

I have few mdb files with multiple tables in it. However, I wanted to read one specific table "Host" from all the files. I am able to do that, but its throwing me an error wherever that table is not existing. I want to ignore the files which does not have "host" table. How can I do that? Please help.

Alteryx Certified Partner
Alteryx Certified Partner

Hi @TarunaT 

 

Have you tried to use a Directory Tool + Dynamic Input Tool?


Cheers,

Nebula
Nebula

Hi @TarunaT 

 

Check out this post specifically the solution that mentions to query the MSysObjects table.

 

SELECT MSysObjects.Name AS table_name
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") 
        AND ((Left([Name],4))<>"MSys") 
        AND ((MSysObjects.Type) In (1,4,6)))
order by MSysObjects.Name 

 

You can run this against each of the mdbs and if the table name is not in the list, then skip this file

 

Dan

 

Dan

Asteroid

Thanks @danilang , it showed me the way to do it !

Labels