Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 spreadsheets.
Spreadsheet 1 Delivery number could appear in Fields ShipmentNumber or ReferenceNumber.
I want the script to do this:
If there is no Shipment Number, I want it to put the reference number in that field.
If (ShipmentNumber is null, ShipmentNumber, ReferenceNumber) as DeliveryNumber.
I have tried a few different scripts, but can't seem to get it to work.
I even tried it this way:
If( [ShipmentNumber ] > '1', [ShipmentNumber], [ReferenceNumber]) as DeliveryNumber
If these are really numbers you can use
Alt(ShipmentNumber, ReferenceNumber) as DeliveryNumber
In qlik the syntax is
If (isnull(ShipmentNumber), ShipmentNumber, ReferenceNumber) as DeliveryNumber.
Otherways if you are loading with a Select and it doesn't work it means that the field is not null (maybe is filled with blank) so add to your condition something like
If (ShipmentNumber is null or trim(ShipmentNumber)='', ShipmentNumber, ReferenceNumber) as DeliveryNumber.
If these are really numbers you can use
Alt(ShipmentNumber, ReferenceNumber) as DeliveryNumber