Force update on transform map?

[Benjamin Nuttin]

I have a simple transform map that maps field from an import set table to a prod table. Problem is, it seems to be ignoring rows it shouldnt (says "No field values changed" even though the data did change). How can I "force update" the transform map, meaning update data in the target table even if it is set to ignore a row? Thanks!

[hartr]

I'm having the same issue. I can see the records in the Source Data have field values that are not showing in the target record even though there is a transform map for them. The transform map is ignoring the rows when it should be updating them.
Did you find a wayto force an update from the source to the target ?
Thanks

[lss123]

I had this same problem today and noticed that the field length on my transform map was too short for the data.   For example, the field type was a string with a length of 40, but the data was a string with length up to 1000.   Apparently it'll just ignore the field?   Once I increased the size of the string on the transform map, it worked.

[johnnyjava]

I know this is an old-ish thread, but when I need to do this for reasons like forcing a new Business Rule to re-process the target records and I need them to be updated from the data source, I just map source.sys_updated_on to a field in the target table and re-process the import set.

[G24]

Thanks @johnnyjava 

I tried mapping "Updated" to "Updated" and that did not seem to work.  But when I mapped "Updated" to a different field like "Notes", then this method did force the rows to be re-processed.

In my case I needed them re-processed so that my source fields with a type of [Script] would run.