Data360 Analyze

In LAE X-ref, we could create a new field for left,match and right outputs.  Could you please show me how to do that with the Merge node?  I'm sure there's a way :)

output 1 {
emit 1:*, "In left only" as Result
where join.leftOrphan
}

output 2 {
emit *, "it matches" as Result
exclude referencedFields(2,{{^RightInputKey^}})
where join.match
}

output 3 {
emit 2:*, "only right" as Result
where join.rightOrphan
}

Switching to the Advanced tab of the ConfigureFields property will display the defaut script used to define the output metadaa for each of the three output pins. The script references the output pins by their index rather than the name (so outputs[0] equates with the top pin which is the left orphans pin). Additional fields can be defined for the outputs as shown below. The value for the output fields are then assigned in the ProcessRecords script.

An example data flow is attached below (requires Analyze v.3.6.0 or above)

Attached files

Merge_Node_Create_Additional_Output_Fields_3.6.x - 18 Nov 2020.lna

Adrien - thank you so much.  I tried many ways similar to this but forgot to address the new fields in the configure!

Thanks for being here,

Sarita.