Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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-
Try these:
text([Customer Material Code])&':' & Text([Sold To])
or
num(num#([Customer Material Code]))&':' & num(num#([Sold To]))
@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]
---
Hi,
Thanks for replying . I tried both the solutions but they arent working for me. They are giving the same result as 323452:3498
Hi,
Thanks for replying . I tried both the solutions but they arent working for me. They are giving the same result as 323452:3498
Can you upload your analysis with this record inside? So we can find the cause and a solution...
Hi,
I have pasted the solutions I have tried.
Thanks
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.