I just noticed this happened in a recent update, that mapping load does not work it used to?
Link to demo QVF, you can download this to check out the scenario.
Assume we have a list of transactions, the SKU field contains things like:
A
B
C
D
E
11
22
33
44
55
And we want to apply map to another reference table:
A: Letter1
B:Letter2
11:Number1
22: Number1
etc
Three ways to do this:
1) Leave the fields untouch, import and load as is
2) Convert the SKU field to text with text() at the load statement
3) Convert the field inside the apply map statement.,
Applymap('SKU to Type',"SKU.Original",'Not Found') as [Mapped Type-Original],
Applymap('SKU to Type',"SKU.Text",'Not Found') as [Mapped Type-Text],
Applymap('SKU to Type',text("SKU.Original"),'Not Found') as [Mapped Type-ConvertApplyMap]
1) doesnt work as expected
2) Works
3) Used to work, now does not work anymore.
My questions:
1) Anyone faced this issue?
2) Is my understanding of the issue correct?
3) Bug? Or Feature?
