Table of Contents
Preface
1
Inputting Data from Files
Technical requirements
Reading a worksheet from multiple Excel files all at once
Getting ready
How to do it…
How it works…
There’s more…
Reading all worksheets from an Excel file at once – same schema
Getting ready
How to do it…
How it works…
There’s more…
Different schema Excel worksheets all at once
Getting ready
How to do it…
Saving and preserving Excel sheet formats
Getting ready
How to do it…
How it works…
See also (follow-up steps)
Accessing and determining which files are to be processed from a file repository
Getting ready
How to do it…
How it works…
There’s more…
Handling formats when reading text files
Getting ready
How to do it…
How it works…
2
Working with Databases
Technical ...
Get Alteryx Designer Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
