Hi All,
I have few csv files that Alteryx cannot read due to a different data structure. Below is a sample of the csv file.
Data is stable from record 13 on, but the files cannot be read by Alteryx because of unwanted data from records 1 through 11. As an alternative, I can open the CSV file manually and save it as an excel file, however this requires a lot of individual effort when there are numerous CSV files. Is it possible to automate this procedure?
hi @Vivek007ktd
You can simply specify option "8. Start Dat Import on Line" to 12, then unnecessary rows are not read.