topic Re: Joining data for time slider in Developers Questions

Joining data for time slider

AlexandruAntonica — Thu, 17 Nov 2016 11:42:09 GMT

Yes , another problem joining the data for timeslider.

Problem:

I'm trying to join the datas from a time based table to a table of a map layer with europes contries. (I will insers picture bellow so you can see better).

Europes table has 32 entries and my table has much more. I'm doing the join based on CNTRY_NAME attribute.

Before I ask the question I searched the web for answers and found this : Possible Solution but this not worked either.

What am I missing here? Or is there any other solution for this ?

Re: Joining data for time slider

AlexandruAntonica — Mon, 21 Nov 2016 23:16:46 GMT

Please, noone knows ?

Re: Joining data for time slider

DanPatterson_Retired — Tue, 22 Nov 2016 01:46:01 GMT

why is France selected? was it selected prior to the join?

Re: Joining data for time slider

ChrisDonohue__GISP — Tue, 22 Nov 2016 04:09:39 GMT

Some ideas:

I suspect you need to do some data cleanup. For example, the MyEurope table shows some Nulls in the CNTRY_NAME field. Therefore you will have to decide what to do with those records, as they lack the information needed to do the Join. If they are needed, populate the CNTRY_NAME field for them as appropriate. If they are not needed, I would export a copy of your data by selecting all the CNTRY_NAME IS NOT NULL and then proceed with that exported file to do the Join. Take some time to go through your data and see if it makes sense.
After you do the Join, save the joined dataset off as a new feature class. This will make the the feature class with the information permanent. Make this layer time-enabled. This can help avoid an wierdness that can crop up due to an active join.

Chris Donohue, GISP

Re: Joining data for time slider

AlexandruAntonica — Tue, 22 Nov 2016 08:56:14 GMT

Yeah but how will this help me to get almost 5000 entries from "Good" table into the "My Europe" table ?

What i want to do is while playing the timeslider(year by year) the europe layers colors should change based on the NO_REF column.
I definetly don't have enough experience with arcgis to say that this is the only method (the one mentioned above).