Concating Columns

[prash_]

I havce to concat :"DG0" Field 1 and "P"

in field 1 there is value 0800 

I used the method concat("DG0",filed 1,"P)

I'm getting result like DG0800P instead of GD00800   (one 0 is not taking after concat) 

What to do in this case?

[AlexT · Accepted solution]

Hi @prash_ 

Can you try to use strval("Field 1")  as noted :

https://community.dataiku.com/t5/General-Discussion/why-concat-function-in-dataiku-erases-zeros/m-p/...

Thanks