When using the file columns in an output table of the file collector, use the format:
<pipe name>.<attribute name>
You do not need to include the name of the target record, or any child records between the target and the attribute node. Using the example grammar and file columns definition from Creating the File Columns for the File Collector, if the file collector was linked to an output table with a pipe named in, you could use the first name from a customer record with the expression
in.firstName
If you defined an attribute FirstName, and wanted it to be populated for both customers and agents, you could use the expression:
ifNull(in.firstName, in.givenName)
If you drag-and-drop file columns from the file collector into an output table (to create attributes), the attribute expressions will be correctly configured automatically.
Learn More