Hi all!
I have a scenario where I'd like to display points listed by respondents in a survey in relation to their home. I have a dataset where every respondent is a row and the long and lat for respective point is a column. The respondents listed 1-8 locations.
I have been able to display the points with 'xy to point', with a separate layer for all locations 1, 2, 3 etc. What I'd like to do now is displaying each point listed by the respondents in relation to their home. I'd also like to be able to highlight all points listed based on each individual respondent and would therefor like to join based on each points corresponding respondent id.
I have gathered that the 'points to line' could accomplish the line between the home address and listed location, but what is the best way to structure the data to join all locations to their respondent?
Best regards.