Question Re: Input field name not found Error:Data cleanse Transform in Technology Q&A

Input field name not found Error:Data cleanse Transform

former_member188628 — Wed, 18 May 2016 09:59:21 GMT

Hi All

I am working on the Data Quality transform ( Data Cleanse transform).Following are the data for the input fields:-

My Data cleanse Editor:- ( I have mapped the input field :Combined Names)

However I am getting an error of "Input field missing " in the error log window during the execution of job

Re: Input field name not found Error:Data cleanse Transform

former_member187605 — Wed, 18 May 2016 11:36:26 GMT

The Data Quality transforms don't support field names with spaces.

Re: Input field name not found Error:Data cleanse Transform

former_member188628 — Wed, 18 May 2016 12:58:03 GMT

Hi Dirk

Thanks a lot for the response.

Thank you

Re: Input field name not found Error:Data cleanse Transform

virginia_hagen — Wed, 18 May 2016 13:49:16 GMT

Dirks' answer is correct for the problem you are reporting, but what I see in your mapping is that you are mapping the same input field to two different lines. This will not error, but what will happen is it will only map into one under the covers and not always give you the results you want.

If you have a input field that is a full name, you have to map it to a input field that is expecting a full name, not the discrete fields that you currently have.

Person_Family_Name1 is discrete field and you would use it when you field only contains last names, such as "Smith"

Person_Given_Name1 is discrete field and you would use it when your field only contains first names, such as "John"

Name_line1 is not a discrete field and you would map full name data to this, such as "John Smith"

Multiline1 is not a discrete field and you would use it when you have name or firm data on a line.