Input field name not found Error:Data cleanse Transform

[former_member188628]

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

[former_member187605 · Accepted solution]

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

[former_member188628 · Accepted solution]

Hi Dirk

    Thanks  a lot for the response.

Thank you

[virginia_hagen · Accepted solution]

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.