Data Table node loses leading zeros on "Text" field ("001" becomes 1)

Questions
1

I think I may have found a bug with the Data Table node, or perhaps I’m misunderstanding a setting.

The Problem

I am trying to write data to a Data Table. One of my columns is shot_number, which needs to store string values with leading zeros (e.g., “001”, “002”, “010”).

Even when I explicitly set the column type to Text (or String) in the table schema, the node seems to auto-convert the value to a number, stripping the leading zeros.

For example, an input value of "001" is written to the table as 1.

2

So you set the type to text.

And how did you store the `001`?

Screenshot_20251110_223251_upIitqkN@2x
Screenshot_20251110_223251_upIitqkN@2x1728×314 19 KB

It’s working on my end.

test field is string

test2field is number

3

If we are storing it manually in the data table string column, it is storing as string.

But when tried to insert string value using data table node it is storing as a number.

So, the issue is still there.

1 Like
4

store it manually is ok, but can’t store the “001” using data table node .