← All features

Canvas nodes

Constant

Fill a column with the same value in every row.

How it works

Name a column and give it a fixed value. The same value is written into that column for every input row.

Click Constant on Canvas, then change Column in the inspector. Every output row has an Online value in Channel.

Simple example

Add a Constant node after loading the online sales file. Enter Channel as the column and Online as the value. Every output row carries the same Channel label.

Constant selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input

3 rows
Order IDAmount
A101140
A10285
A103220

Node output

3 rows
Order IDAmountChannel
A101140Online
A10285Online
A103220Online

Complex workflow

Combine online and store exports without losing where the rows came from. Add a Constant node to each input and write Online or Store into a shared Channel column. Union the two outputs, then group by Channel to compare totals.

Constant selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input

3 rows
Order IDAmount
A101140
A10285
A103220

Node output

3 rows
Order IDAmountChannel
A101140Online
A10285Online
A103220Online

Workflow result

First 5 of 6 rows
Order IDAmountChannel
A101140Online
A10285Online
A103220Online
A20154Store
A20271Store