Copy the data from a zip of csv files to a managed table – SolveXia

When you have a collection of csv or text files in a consistent format (i.e. column structure), you can import them to a managed table via a single step by putting multiple csv/text files into a zip file.

Step-by-step guide

To import a zip of csv/text files to a managed table

Zip your csv/text files together
Upload the zip file from step 1 above into a data step in SolveXia and link that zip file to the "Copy from Text/CSV to Managed table" instruction:

SolveXia will notice that the source is a zip file and react by repeating the action configured (for that instruction) on each file contained in the zip.

Tips:

1. When doing this, you most likely want to append the data from the various files (in the zip) to the managed table. Thus, you want to make sure that "Clear old data" is NOT ticked - as this will clear the managed table on each loop. If you need to clear the table before processing this instruction, we suggest adding a "clear table" instruction (prior to the "Copy from Text/CSV to Managed table" instruction).

2. Instructions that support zip files are hinted with the +1 in the link symbol .