Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
You probably want '000' not the number 000.
Field Value is showing wrong in data Preview
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 25%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
ARUP DEBBURMAN
21
Reputation points
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
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT 26,236 Reputation points2021-06-14T20:52:50.107+00:00 @ARUP DEBBURMAN we haven't heard back from you. are you still facing the issue?
Sign in to comment
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 17%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kiran-MSFT 696 Reputation points Microsoft Employee2021-06-07T00:37:16.953+00:00 -
MartinJaffer-MSFT 26,236 Reputation points
2021-06-07T19:54:49.387+00:00 Hello @ARUP DEBBURMAN and welcome to Microsoft Q&A.
@Kiran-MSFT is correct.
The reason you are seeing
0, not000, is because you chose that column to be integer. As a number,0is 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'not000as Kiran said.
Sign in to comment -