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.
We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!
Reply with your "why" in text/video format to our forum post by January 28 to be entered!
we struggle to import multiple data files (varies between 9 to 15) of not supported data type to a workflow provided on the gallery (we use a lot of interface tools).
What has been done:
Previously we achieved this (for other not supported data files) by using a combination of the directory tool, blob and text-to-columns.
Unfortunately the data files in question do not have a delimeter but a fixed length (variable) to distinguish columns.
Text-to-column can not be used, since the directory tool simply puts the information (lacking structure or a delimeter) in one row.
We managed to get the data (of one file) in shape by importing it as a "fixed width text file" and creating a flat file layout for future reference.
Any suggestions how to either import:
Option 1:... the files in one fell swoop (user perspective)
Option 2: ... variing amount of files without requiring the user to import the "flat file layout" as well
I am open for other options as well as long as it gets the job done 😄