Load Script - If/Then

[#1]

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

[alexandros17]

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.

[stigchel · Accepted solution]

If these are really numbers you can use

Alt(ShipmentNumber, ReferenceNumber) as DeliveryNumber