How can we help?

New post
0

Answers in questionaire don't line up with right reference number in JSON file/Modelling data source

Avatar
Kim Timmermans
None
Follow

I'm trying to make a modelled data source looking like this:

Ref; Text/Number

90ea892d... ; Gehandicaptenzorg

13b95396... ; 8

I can't seem to get the answers to line up with the correct reference code, because there are answers with two different types (text and number). I would be fine with one column for the numbers and one column for the text-answers but I'd still need them to correspond to the right reference. I've been trying to use LOOKUP and GROUP but can't seem to get it to work. Any tips?

Date Votes

3 comments

  • Avatar
    Shima Beigzadeh Official comment

    Hi Kim, 

    Thanks for posting on our community! 

    One thing that may help here is using syntax kf:fill_elements(path,'fieldname') in order to get all the references first.

    This function is used to “fill in” blanks for an element that is not included in every record. This is useful for data alignment.
    Also, it is important to know if we have Text or Number for every record. If not, you would need to align those as well. 

    Each JSON datasource might have different structure and that can affect on the XPATH you need to use. We can take a look further into your account and your JSON datasource if you would like to enable support access here. 

    Hope that helps! 
    Shima

  • 0
    Avatar
    Kim Timmermans

    This fixed it, thanks! Is there any way to learn more about these types of (advanced) functions? I'd like to learn more so I won't have to ask about every hitch I encounter (more than just the explanations on the support pages).

  • 0
    Avatar
    Meggan King

    Hi Kim,

    This guide on our site should help: https://support.klipfolio.com/hc/en-us/articles/215547118 

    You can also search for XPath online to learn more standard ways of working with the data. 

    Thanks,

    Meggan

Please sign in to leave a comment.