The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options

Parsing Xml From Excel field

elio_rizkallahelio_rizkallah Member Posts: 1 Contributor I
edited December 2018 in Help

Dear all, 

I have an excel sheet that contains a column called ColumnSet that comtains xml data. 

How could i parse the xml data from this column in the .xls file?

 

 

Regards,

Elio

Answers

  • Options
    sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager

    hello @elio_rizkallah - welcome to the community.  Yes for sure.  Is there a different XML in each cell in the column?  That would be a little weird but you can deal with it.  Basically what I would do is use Read Excel, grab that column you want and convert it to text, loop examples and Write Document for each XML cell contents.  Then use Loop Files on those XML documents and use Read XML inside.


    Scott

     

Sign In or Register to comment.