Hi Chris,In Sparkflows, we can use the “Fixed Length Fields” processor to split the dataset into multiple columns based on fixed length. Output would contain columnar data which can be loaded into the database or can be used for further processing.
To use the “Fixed Length Fields” Processor:
Select a ‘Input Column’ that contains joined data.
Specify the ‘Column names’, ‘Column type’ and ‘Length’. Processor would split the data based on the column length and list them under multiple columns in the output.
For more information read the Sparkflows Documentation here:
Hi Chris, In Sparkflows, we can use the “Fixed Length Fields” processor to split the dataset into multiple columns based on fixed length. Output would contain columnar data which can be loaded into the database or can be used for further processing.
To use the “Fixed Length Fields” Processor:
Select a ‘Input Column’ that contains joined data.
Specify the ‘Column names’, ‘Column type’ and ‘Length’. Processor would split the data based on the column length and list them under multiple columns in the output.
For more information read the Sparkflows Documentation here:
https://docs.sparkflows.io/en/latest/user-guide/data-preparation/parse.html?highlight=fixed%20length%20fields#fixed-length-fields