LookUp Transform - Description Unclear

[GOKUL_ANANTH_M]

Hi Everyone,

I’ve been going through the transforms and came across something unclear regarding the LookUp transform.

In the attached image, there is a LookUp transform where multiple keys (“281”, “713”, and “832”) are associated with the same value, “Houston.” From my understanding, this should be possible with the LookUp transform.

But, the description above to that transform says that, “this transform will throw an error, as duplicate key values are not allowed”.

I believe the transform will only throw an error for inputs that don’t match the given keys, since there is no default specified.

Is my understanding correct?

[Abhishek_1995 (Abhishek Kumar)]

Hi @GOKUL_ANANTH_M ,

Yes, you are correct if the value didn’t match it will give an error. it required the default value then it will not throw the error.
If the value didn’t match then it will take default value.

Thank you.

[GOKUL_ANANTH_M]

So, my question is that, the description given to that is missing something correct?
I think duplicate values shouldn’t be a problem. But still, the description is slightly unclear right.

[sauvee (Edwin Sauve)]

no, duplicate values are not a problem but duplicate keys are.

Example:

"a":"hello"
"b":"hello"

Will be fine

"a":hello"
"a":bye"

Will not be fine

[GOKUL_ANANTH_M]

Thank you @sauvee .

I have little bit confused. It’s fine now.

[MVKR7T (Krishna Mummadi)]

I believe this image is bit old, 2 years back default key was not mandatory, but now default is mandatory for lookup transform.