In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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