Google Drive Input Tool - For reading multiple files from the Google Drive

Question

HI,

We have a requirement to read multiple files from Google Drive, and write them in MYSQL DB. We are able to write the individual files to MYSQL DB, but how to read each file sequentially and load in to the DB into corresponding table one by one ?

Thanks,

Preeti

PreetiK · Answer

Thank You for your reply Yoshiro! I am going to try that with Batch Macros and update here.

Yoshiro_Fujimori · Answer

Hi @PreetiK ,

I do not use Google Drive Input Tool.

But in general, Batch Macro may come in handy when you want to repeat the same procedure with different parameters.

As a similar use case, the way to read data from multiple Excel Files is described in the Knowledge Base below.

https://knowledge.alteryx.com/index/s/article/Read-in-Multiple-Excel-Files-with-Multiple-Tabs-that-have-Different-Schemas-1583460903182

1. On the main workflow, create a table of "Full Path" of the files you want to read.

2. On the Batch Macro, connect Control Parameter Tool with Google Drive Input Tool to replace the "Full Path".

If you are not familiar with Batch Macro, I recommend watching Interactive Lesson "Creating a Batch Macro" first.

https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923

Good luck.