question

ARUPDEBBURMAN-2424 avatar image
0 Votes"
ARUPDEBBURMAN-2424 asked MartinJaffer-MSFT commented

Field Value is showing wrong in data Preview

I have created a derived column Row_ID with Static value as Number 000 in visual expression builder but preview time its showing only single digit as 0

102540-capture-issue.png


azure-data-factory
capture-issue.png (50.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ARUPDEBBURMAN-2424 we haven't heard back from you. are you still facing the issue?

0 Votes 0 ·

1 Answer

Kiran-MSFT avatar image
0 Votes"
Kiran-MSFT answered MartinJaffer-MSFT commented

You probably want '000' not the number 000.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ARUPDEBBURMAN-2424 and welcome to Microsoft Q&A.

@Kiran-MSFT is correct.

The reason you are seeing 0 , not 000 , is because you chose that column to be integer. As a number, 0 is the canonical form for the value of zero. 000 = 00 = 0 , all are the value zero.

If you care about the presentation, you will need to change the column's data type to string, and use the text value '000' not 000 as Kiran said.

0 Votes 0 ·