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 combining the mutliple csv/text files as 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 "Import from text 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 "Import from text" instruction).
2. Instructions that support zip files are hinted with the +1 in the link symbol 
.
Comments
0 comments
Please sign in to leave a comment.