Transform maps - how to import data to referance field with over 32 char

[bartk]

Hello Community,

I am trying to help client, who need to connect risk statements with control objectives.

In transform maps we match it with valid referance field in target table.

As a result I got 64/319 inserts.

Only control objectives which are less than 32 characters are uploaded and correctly mapped, the rest is skipped by transform map.

Any ideas why it is like this, and how to fix it?

Thanks in advance 

[Mark Manders · Accepted solution]

That's because it can't find the correct records. You need to to to your import set table and adjust the size of the field to at least have the minimum length of the longest input value, so it can be mapped properly.

If it can't find the exact match in the table, it will return nothing.

[bartk]

Thanks Mark, that was exactly this