topic Re: Joining two tables in QlikView

Joining two tables

Vinni2000 — Mon, 08 May 2023 17:48:49 GMT

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

Re: Joining two tables

BrunPierre — Mon, 08 May 2023 18:45:01 GMT

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;

Re: Joining two tables

Kushal_Chawda — Mon, 08 May 2023 20:04:56 GMT

@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