Hi there,
I want to produce a cascading parameter to filter by local authorities(LA)and then by ward. However the dataset I have only gives me the LA code, not the name. There is no lookup table for the LA. Furthermore as there are over 150 LA's in the UK I want to filter this list to only display the LA's I am working with(around 10).
The ward code is on the LA table but there is a another lookup table that contains the description for the Ward.
How can I go about doing this?
I've tried a cascading parameter, set it to dynamic and entered the LEA code and then the Ward Code. When I run it I don't get the full list of LA's, is there a restriction on the number it can return?
I want to produce a cascading parameter to filter by local authorities(LA)and then by ward. However the dataset I have only gives me the LA code, not the name. There is no lookup table for the LA. Furthermore as there are over 150 LA's in the UK I want to filter this list to only display the LA's I am working with(around 10).
The ward code is on the LA table but there is a another lookup table that contains the description for the Ward.
How can I go about doing this?
I've tried a cascading parameter, set it to dynamic and entered the LEA code and then the Ward Code. When I run it I don't get the full list of LA's, is there a restriction on the number it can return?