0

Not possible to add blanks to an XML

Dear community,

I have a problem concerning XML data with empty rows (from Matomo - web analytics on a daily basis with occasional days without any users).

What I'd basically like to do is to use the Select all <field name> elements in all <parent> elements, adding blanks for missing <field name> elements selection option (as shown on https://support.klipfolio.com/hc/en-us/articles/215547118-About-JSON-and-XML-Data-Sources).

However this option is not displayed. I only have six options and adding blanks is none of them.

When I try to use @kf:fill_elements operator manually, an error occurs: There was an error fetching the results for the model.

Is there a general answer for reduced selection options in XML data?

Thanks in advance!

1 comment

  • 0
    Avatar
    Meggan King

    Hello,

    XML does not support our KF functions. This means you'll need to align your data using functions like LOOKUP or MAPFLAT. The support team can help and have a look. Depending on your data service, some APIs allow for JSON or CSV instead of XML. That might also be an easier option to work with if possible.

     

    Thanks!

Please sign in to leave a comment.