Import txt file in dataset
Hello, i have a txt file fidex-width. When import the file in dataset DataIku not respects the position of string a so when i extract the data from the selected row in col_0 the position change. Example if in the original file the amount is substring in position 9 for 9 carachter after i have import the file this positione change for the first and the other rows and it is differente for each rows. This seems the work impossible whit the text file. I hope explanation correctly. Thanks for the help.
Operating system used: Windows 11
Answers
-
this is the file that i want to upload in dataiku with fixed-width
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,123 Neuron
Your sample file is not a proper fixed width text file. Below is a sample of how a typical fixed width text file looks like. Your sample file appears to be a text file that has been calibrated to print like an invoice or similar document. Aside from the multi line header and column headings you then have multi line values and totals with dashes which break the data patterns. You can't really expect Dataiku to understand this format. You will need to write custom Python code to load this file.