Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Parsing Xml From Excel field
elio_rizkallah
Member Posts: 1 Learner II
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
Tagged:
0
Answers
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