This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How to load three hundred ninety thousand files with the same format in a Teradata database. The tables are PrimaryScreen Misschargespantalla DIM chargesscreen for the load and I want to save the column and the value... how can I design it?
Basically you would build a workflow that can XML parse one of the files (Alteryx has a tool for that), then add interface inputs (macro input, control parameter and macro output). Then you'll build another 'outer' workflow that reads in a list of all the files (ex. from a Directory read tool) and passes that into the macro. The macro would then take care of reading in each file, and parsing it out the way you did as a single file. As a final step in your outer macro, you can do a database output to Teradata.