Integration Hub ETL Field Mapping to Choice List fields

[Alec Hanson]

Hi,

I am starting to use the IntegrationHub ETL to pass data loads into the CMDB through the RTE & IRE.

However if the data has a field (e.g. Environment) that maps to a Choice List field in the target table, any invalid data just gets entered in rather than the row being ignored.

When using Load Data / Import Sets there used to be a 'choice action' where you could select Ignore / Reject so that invalid data was not entered into the CMDB.

Does anyone know if this is available in IH-ETL as I can not find an appropriate option - or is this meant to be handled another way?

Thanks

[#2]

I'm not aware of any OOTB functionality for this.  It sounds like a good product enhancement.
You could handle this via a script operation.  You could query the sys_choice_list table to see if the value exists.  You could add a true/false property to either null out the output if the value doesn't exist or pass that value along to be created.

[Alec Hanson]

Hi, Thanks,

It does seem strange that this is not an OOTB function considering it is part of Import Sets, even if the LoopUp transform operation could look up the sys_choice_list table which I did try.

Looks like a script is what will be required.

Alec

[Tone1]

I just stumbled upon the same problem when using ETL, do you have a solution for this with a custom script?

[pratiksha5]

@Tone1, 

Try script transform. Whatever value you are getting from the source match it with the target choice "value". If found you can populate if not you can create (Depending on what you want to do).  

Or you can simply do this like this. loading data in file system table. And the input data is same as the choice value. It will directly work