Error in Real time job

[Former Member]

Hi,

We have created a real time scenario where we are comparing data from web service (nested XML) and CRM tables data and generating Unique and duplicate Records using Base_Match transform of Data Quality.

Job is validated successfully , but when we are executing the job with sample data , we are getting below error:

<Table> for column <field> doesn't occur in the FROM clause, for a top level query all columns must belong to some table in the from clause

Please help us in sorting this error and let us know if any other information is required from our end

  Attached documents     

1.Full job

2.Data from XML file

3.Data from CRM table

Joining condition as :Query.nameSur=Merge.nameSur and Query.ElectronicAddress.eAddress=Merge.eAddress

Thanks,

Venkat

[former_member187605]

You will find the explanation on this wiki page: The Nested Relational Data Model NRDM - Enterprise Information Management - SCN Wiki

[severin_thelen]

I can not see a table with the column "field". The error sound like an job update issue. So previous you used a table with the column "field" but after deleting this table, the field column still exists.

Please check if you use a column named "field"?

Regards

Severin

[Former Member]

Hi,

We are not created with any column name as  'field'.

Please let us know