Scenario

You only have one source and want 1 record per input record

Solution

The below screenshot shows how to configure a calculate

table that pulls data from a file.

All attributes just refer to the source file collector

or

table with the pipe name and attribute name, for example in.AccountName.

Image Modified