is it possible to add a new column that contains user-input data for different rows.

[kelvenlim]

The image shows 3 different canteen locations. For each canteen, I want to add a column that shows the seating capacity.

For example, B73: 1560, B22: 2070, B51: 2751

Is there a way to do this?

[ShankerV]

Hi @kelvenlim 

If you have the seating capacity in the same input, then you can use Formula tool to combine Canteen location and Seating capacity.

If it is in a different dataset, then request to join both the datasets using join tool and then use the formula tool.

Many thanks

Shanker V

[kelvenlim · Accepted solution]

Nvm, I can use the text input tool and join the tables afterwards. Thanks for the replies.

[ArtApa]

@kelvenlim  - Here is a solution for you: