hi ,
I have Counties like Adams, York, Allegheny etc like 67 counties in PA map I need to map like 4 regions with my calculated filed . I am trying case statement but not taking multiple values as in() . please help through it thank you.
CountyRegionAdamsCentral RegionAlleghenyWestern RegionArmstrongWestern RegionBeaverWestern RegionBedfordCentral RegionBerksSoutheast RegionBlairCentral RegionBradfordNortheast RegionBucksSoutheast Region
7 answers
Hi Priyanka,
I too struggle with this, being most knowledgeable in Python.
In Python, I could say if [str] in [array]
In Tableau, there is no equivalent, as fields in Tableau cannot be treated as arrays.
Yes, you could write a 67 line calculation to map each county, but I suggest creating a mapping table and joining to it.
