I am working on a school project and am having some issue figuring this out. My team and I’s problem is that we have 24 XML files from our sponsor (they make custom garage doors), and it is unstructured data that needs to be organized to be able to determine trends, patterns, etc. We need help on figuring out how to create a mock database for those 24 files so Alteryx can pull from the DB instead of entering each file individually, (since the sponsor has millions of files it wouldn’t work to enter each individually).
The sponsor’s current situation is that they pull text files from an Oracle DB that are made into XML files when extracted. My team doesn’t have access to the Oracle DB so we need to make a mock DB (doesn’t have to be Oracle) that will mimic this to show how Alteryx can structure the unstructured data.