Incorrect concatenation happening

[debmsarkar123]

This is the loading statement-

Temp:
LOAD [Customer Material Code]&':' & [Sold To]
Material,
[Sold To],
[Customer Material Code]
FROM
$(vDataFolder)Material.qvd
(qvd);

This is the output-

Customer Material Code is '323494' and Sold To is '978' but a concatenation of them is becoming '323452: 00003498'.

I have tried making all the fields to num# but its not working too.

Edit-

SS of the solutions I have tried-

[micheledenardi]

Try these:

text([Customer Material Code])&':' & Text([Sold To])

or

num(num#([Customer Material Code]))&':' & num(num#([Sold To]))

[Andrei_Cusnir]

@micheledenardi 's solution is very good and should work perfectly! I was also able to resolve this issue with:

Num([Customer Material Code])&':' & Num([Sold To])

and 

REPLACE(LTRIM(REPLACE([Customer Material Code], '0', ' ')), ' ', '0') &':' & REPLACE(LTRIM(REPLACE([Sold To], '0', ' ')), ' ', '0') as suggested in the post "Remove Leading Zeros from Field while loading" [1]

---

[1] https://community.qlik.com/t5/QlikView-App-Dev/Remove-Leading-Zeros-from-Field-while-loading/td-p/16...

[debmsarkar123]

Hi,

Thanks for replying . I tried both the solutions but they arent working for me. They are giving the same result as 323452:3498

[debmsarkar123]

Hi,

Thanks for replying . I tried both the solutions but they arent working for me. They are giving the same result as 323452:3498

[micheledenardi]

Can you upload your analysis with this record inside? So we can find the cause and a solution...

[debmsarkar123]

Hi,

I have pasted the solutions I have tried.

Thanks

[micheledenardi]

Can you please post your .qvf / .qvw file? There is something strange in your data... without the live data is very difficult to help you... maybe only the Material.qvd would be sufficient.