LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jagdev

Hi Experts,

I am finding strange error while trying to execute Deepref node. The graph attached with the mail. Please let me know what I am doing wrong here.

Also, When I test with the Static data it is working fine and when I try with excel node it is throwing error.

I am using 6.1 version and that to on citrix server. I don't know if this could be a issue for this

Regards,
Jagdev
Attachments:
DeeprefError.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mlam

Hi Jagdev,
Can you please provide more details on the error that you see?


Michelle

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jagdev

Hi,

Please find the error image attached.

Regards,
Jagdev
Attachments:
Capture.GIF

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

This error will be generated by the Deep X-Ref node if there is no overlap between names of the non-key fields in the left data set and names of the non-key fields in the right data set.

Your data must have at least one non-key field with the same name in both data sets.

The purpose of this node is to validate that the contents all non-key fields is the same in a record (where the records are identified by the key values).
If the AllowPartialOverlap property is set to true then the values of the fields where there is an overlap (field name is present in both data sets) are checked.

The field name match is case insensitive.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Here is an example that shows both the error state and the successful operation of the node.

Deep_X-Ref_Example.brg

Regards,
Adrian

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jagdev

Hi Adrain,

Thanks for the sample and explanation as well. I am able to run the node now. I have few queries regarding the Deepref node.

Is it mandatory to have the same name column header in both the data sheets
What is Partial match? What does it extract exactly?

Regards,
Jagdev

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi Jagdev,

The Deep X-Ref node is really a data profiling tool. Typically it is used to validate that the contents of two data sets are exactly the same (for records where the key fields match). The node uses the name of the non-key fields to identify the pairs of columns that are to be validated. Because of this the names must be exactly the same (case insensitively). By default, the node will attempt to pair all non-key fields in the left data set with the non-key fields in the right data set. If there are 'extra' fields in either set which are not matched the node will error (i.e. "Fields on input data sets do not match."). In the case where your data has additional fields in one or both of the data sets, setting 'AllowPartialOverlap' to true will make the node only compare the sub-set of fields where there was a match in the field names, the other 'extra' fields are then ignored.

Regards,
Adrian

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jagdev

Hi Adrian,

Thanks for the explanation!

Regards,
Jadgev