Help converting xml file to to xlsx file
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
srk0609
8 - Asteroid
‎08-01-2022
03:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Can anyone please help to convert xml file to xlsx file? Thank you
Labels:
2 REPLIES 2
14 - Magnetar
‎08-01-2022
04:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI @srk0609 ,
Your sample files are not readable, but after bringing you data in, start with the XML Parse tool, then cleanse and format data as needed to match your desired format.
apathetichell
19 - Altair
‎08-01-2022
05:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can't parse this because one of your tags is wrong... Your first </MX_FX_Specific> is missing the "/"
