MergeColumns

Combines two or more columns into a single text column, joining each row's values with a delimiter. The merged column takes the place of the first column in your list, the originals are removed, and everything else stays put. A common use is building a composite key (entity plus account, or customer plus date) before matching tables.

Inputs

Input	Accepts	Required
`Table`	Table	Yes

Outputs

Output	Produces
`Result`	Table

Settings

Typed in on the node or set by the assistant, not wired.

Setting	Default	Notes
`Columns`	—	Choose one or more columns from the connected table. Comma-separated list of at least two columns to combine, in the order their values should appear (e.g. `Entity,Account`).
`Delimiter`	—	Text placed between the values, such as `-` or a space. Leave blank to run the values together with nothing in between.

Example

Your Ledger table has Entity and Account columns, but your mapping table keys on a combined code like US01-4000. Set Columns to Entity,Account and Delimiter to -. The result, with a new Entity_Account column, appears as its own tab. Rename it to match the mapping table and it is ready for a Join.

Tips

The merged column is named from the originals joined with underscores (Entity_Account); use RenameColumns if you want something shorter.
Blank cells merge as empty text, so US01 with a blank account becomes US01-.