I should have gone into more detail. ProcessEndHour does already exist in RPACash.qvd which is being generated by SQL. It is just the hour from the timestamp so 1,2,14,17, etc. With the the apply map I am trying to say if there is a mapping I missed,then just show the hour number. The error message I receive is that HourInterval does not exist even though I have that in my mapping load.
Since ProcessEndHour does exist in my qvd that is being loaded, this is being used as the Key field between the qvd and the mapping table. I want to replace 1 with '1:00 am - 2:00 am' and so on.
No, HourInterval does not exist in the qvd. It is being created in the mapping load and is the field I need mapped. It should be looking at ProcessEndHour from the mapping and the RPACash table and replacing ProcessEndHour from the QVD with the HourInterval from the mapping table. If no match is found then I have it set to use ProcessEndHour from the qvd. From what I can see I am following the directions as provided on the help page.