# Help with RSS parsing

**URL:** <https://forum.knime.com/t/help-with-rss-parsing/24725>\
**Category:** KNIME Extensions\
**Tags:** text-processing\
**Created:** [June 21, 2020, 1:29am UTC](https://forum.knime.com/t/help-with-rss-parsing/24725 "2020-06-21T01:29:13Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![RPS](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/9e8a1a/32.png) [@RPS](https://forum.knime.com/u/RPS)\
**Post date:** [June 21, 2020, 1:29am UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/1 "2020-06-21T01:29:13Z")

</div>

Hello KNIME users,

I am a relatively recent user of KNIME and need help with the attached workflow. I am also not an IT/Software professional.

I am trying to extract publication metadata from [DBLP](https://dblp.uni-trier.de/). Metadata is available for individual authors and as a test case, I am attempting to extract information for the following author:  
[Albert Zomaya](https://dblp.uni-trier.de/pers/xs/z/Zomaya:Albert_Y=.rss)  
Being new to KNIME, I have followed a workflow that is available on the hub that I have downloaded.

> **[RSS Feed Reader – knime](https://hub.knime.com/knime/spaces/Examples/latest/08_Other_Analytics_Types/01_Text_Processing/15_RSS_Feed_Reader~dm0-c97PFOyllWyR)**
>
> The workflow starts with URLs to some RSS news feeds. The news feed is downloaded, parsed and transformed in documents. Names of persons, organizations and loc…

My workflow is also attached[KNIME\_project\_DBLP.knwf](https://forum.knime.com/uploads/short-url/humlbmQAm1afVs9qpzAd3SdtR8C.knwf) (14.1 KB)

The RSS feed data that is in the description column needs to be cleaned and I have done it using the cell splitter but unable to scale it up across the full dataset.

How do I clean up all the ‘garbage’ in the Description column of the RSS output? Is the column filter and cell splitter the right tools to use?

Any help will be greatly appreciated.

Thanks,  
RPS

---

<div class="post-metadata">

**Author:** ![Matt\_D](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/e495f1/32.png) [@Matt\_D](https://forum.knime.com/u/Matt_D)\
**Post date:** [June 22, 2020, 2:57pm UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/2 "2020-06-22T14:57:47Z")

</div>

Hi @RPS,

I’ve not had a chance to look at this properly but I noticed you can return the data as xml too.

[Albert Y Zomaya](https://dblp.uni-trier.de/pers/xx/z/Zomaya:Albert_Y=.xml)

There’s an XPath tool which may make this process easier, I’m not an expert but I know some of the respondents on here have a higher xml knowledge so maybe able to parse this for you.

---

<div class="post-metadata">

**Author:** ![RPS](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/9e8a1a/32.png) [@RPS](https://forum.knime.com/u/RPS)\
**Post date:** [June 22, 2020, 10:33pm UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/3 "2020-06-22T22:33:51Z")

</div>

Hi @Matt_D,

Thanks for your response. I have tried the XPath tool and didn’t get any success. In fact I cannot even configure it and get the message: “The dialogue cannot be opened for the following reason: No column spec compatible to XMLValue”.

The thing is that I get a similar error in Alteryx (which I am more familiar with) so I am beginning to wonder if the data structure (for both the RSS feed and XML file) is flawed? Since I am not a computer guy, I can’t say if this is the case.

Regards.

---

<div class="post-metadata">

**Author:** ![Matt\_D](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/e495f1/32.png) [@Matt\_D](https://forum.knime.com/u/Matt_D)\
**Post date:** [June 23, 2020, 12:39pm UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/4 "2020-06-23T12:39:55Z")

</div>

Hi @RPS,

I used to use Alteryx, loved that software.

I can get some time one morning this week to give you a hand with this, I have made some progress for you. Is there something specific you need from the data?

I spotted that there are different keys within the file relating to -

article key  
book key  
incollection key  
inproceedings key  
proceedings key

these all contain a slightly different xml structure (data). It’s a pain for a novice like me but I’m learning a great deal so thank you!

If you can narrow down what you need (specific data headers) it’ll be easier to try and help you out with the specific instead of trying to ingest it all. I don’t know anything about this data which makes it tough… 🙂

Let me know, I’m sure we can solve this.

Matt

---

<div class="post-metadata">

**Author:** ![RPS](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/9e8a1a/32.png) [@RPS](https://forum.knime.com/u/RPS)\
**Post date:** [June 23, 2020, 11:05pm UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/5 "2020-06-23T23:05:08Z")

</div>

Hey Matt,  
Good to be able to talk to someone who has also used Altleryx (and so can feel some of the pain I am feeling 😁 )

This is an extract of research publishing data and the different keys that you mention are the different ‘platforms’ (if you will). For instance article key relates to all research publications in journals. Likewise book relates to published books and proceedings relate to publications presented at various conferences.

For a start if I could extract Journal publications that would be great. One thing I have done (and I am building a parallel workflow in Alteryx) is to download the RSS feed and used the XML parser to read the file. Doing this, I am able to filter out the different publication types using a filter (I get a GUID field in Alteryx which I cannot see in KNIME).

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/5/5/55066581a46128b9a38adb132a32b57ae60520e5.png)

I am glad that this is helping you learn as am I. I have a meeting with a colleague at work who knows a bit more about XML than I do and hope to find out more. I will let you know if I get ahead or find something that would help with this workflow.

I am also trying to replicate all of my Alteryx workflows into KNIME so that will be a challenge in itself.

Thanks again for your help, it is greatly appreciated.

Cheers  
RPS

---

<div class="post-metadata">

**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\
**Post date:** [June 29, 2020, 2:58pm UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/6 "2020-06-29T14:58:19Z")

</div>

Hello there!

Just to add that for easier transition there is [From Alteryx to KNIME](https://www.knime.com/knimepress/download-from-alteryx-to-knime) free guide/book.

@RPS did you have some progress on your workflow?

@Matt_D welcome to KNIME Community!

Br,  
Ivan

---

<div class="post-metadata">

**Author:** ![Matt\_D](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/e495f1/32.png) [@Matt\_D](https://forum.knime.com/u/Matt_D)\
**Post date:** [July 17, 2020, 2:04pm UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/7 "2020-07-17T14:04:07Z")

</div>

@RPS hello!

I had an unexpected absence so wasn’t able to work on this for you, did you find a solution?

Happy to continue to help if you need me too.

Thanks,

Matt

---

<div class="post-metadata">

**Author:** ![DemandEngineer](https://forum-cdn.knime.com/user_avatar/forum.knime.com/demandengineer/32/26048_2.png) [@DemandEngineer](https://forum.knime.com/u/DemandEngineer)\
**Post date:** [October 30, 2020, 9:59pm UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/8 "2020-10-30T21:59:12Z")

</div>

Hi @RPS,

I’m also coming from Alteryx… hope this helps you:

> [@Alteryx Designer to Knime](https://forum.knime.com/t/alteryx-designer-to-knime/28125/2):
>
> Here is a [shared google sheet](https://docs.google.com/spreadsheets/d/1ecvnm5f-kDhu45CwlQrqmAdct7fyrAHimgUIqP1fxGc/edit?usp=sharing) expanding on the eBook From Alteryx to Knime. Let’s crowd source this and update the Knime tools that would be used to replicate the same functionality. [https://docs.google.com/spreadsheets/d/1ecvnm5f-kDhu45CwlQrqmAdct7fyrAHimgUIqP1fxGc/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1ecvnm5f-kDhu45CwlQrqmAdct7fyrAHimgUIqP1fxGc/edit?usp=sharing)

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [May 1, 2021, 9:59am UTC](https://forum.knime.com/t/help-with-rss-parsing/24725/9 "2021-05-01T09:59:51Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.
