Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert csv file into excel using python tool

Vivek007ktd
7 - Meteor

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. 

CSV sample.PNG

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?

 
 

 

1 REPLY 1
gawa
16 - Nebula
16 - Nebula

hi @Vivek007ktd 

You can simply specify option "8. Start Dat Import on Line" to 12, then unnecessary rows are not read.

image.png

Labels
Top Solution Authors