Joining two tables

[Vinni2000]

I want to join two qvds so I have order number and item number common fields between these two qvds but issue in first qvd I have item number like this 1 , 2 ,3 and in second qvd I have item number like with leading zeros 0001 ,0002 ,0003   so how can join these qvds 

[BrunPierre]

Hi,you could truncate the item number with the leading zeros to conform to the other. This should be the easiest way.

LOAD
Num("Item Number") as "Item Number"
...

FROM SecondQVD;

[Kushal_Chawda]

@Vinni2000  if it is in Number format you can try what @BrunPierre  mentioned. But if field containing 001.. text you can try below to make it in number format and then join

LOAD Field1,
     Field2,
     replace(Ltrim(Replace([Item Number],0,' ')),' ',0) as [Item Number]
FROM Source;

or

LOAD Field1,
     Field2,
     num(num#([Item Number])) as [Item Number]
FROM Source