I have 2 csv (these belong to Network dataset of arcgis; speed profile and daily profile). The SpeedProfile table consists of weekly patterns id (i.e for S M T W T F S) for various road links. These pattern id corresponds to hourly freeflow speed (1 hr interval). Basically this tells that for a particular road on a particular day of week what is the hourly speed variations. But arcgis needs data to be in speed factor or scale factor i.e. Freeflow speed / Speedlimit
In order to obtain this I am trying to populate my speedprofile table with the pattern Id of each day so that I can divide the freeflow speed with speedlimit, get the scale factor, create a new table of these scale factor and repopulate fields with that table. But using FME I am not able to join the attributes for all the days, only 1 of them is getting joined. Any pointer on how can I overcome this?
More details on tables: Historical traffic—Help | ArcGIS Desktop
Attached is the speed profile table with column UMTWRFS being the day of weeks and having the pattern ID such as 59
And daily profile table having Pattern ID and associated speed on hourly basis such as H00_01 which tells speed at 1 AM
