Scenario

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

Solution

The below screenshot shows how to configure a calculate stream table that pulls data from a file.

All attributes just refer to the source file collector ( or stream) table with the pipe name and attribute name, for example in.AccountName.