Convert csv file into excel using python tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Vivek007ktd
7 - Meteor
‎10-04-2023
11:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
1 REPLY 1
16 - Nebula
‎10-05-2023
01:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @Vivek007ktd
You can simply specify option "8. Start Dat Import on Line" to 12, then unnecessary rows are not read.
