Using a Calculate Table

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.