Xpath Can't Create List When Using normalize-space

I was trying to help another KNIMER with some web scraping and ran into an Xpath problem. The original thread is How to pull data from a website that does not have an API? - #3 by rfeigel

This problem seems generic so I thought I’d start a new thread.

Here’s the workflow:

Simple Web Scraper.knwf

The xml is not very well formed. It consists of monthly data with an extra flag for the current year. There is a lot of extra white space in the value field. If I try to remove the white space the Xpath query won’t allow a list, only a single entry which gets stuck on the first data field. Here are a series of screenshots which hopefully will clarify the problem. I’ve done quite a bit of searching and haven’t found any help.

Blockquote