Making a Flag over one field on basis of another field

[koushik_btech20]

I am facing a problem on creating a flag(Shipping Status). In my data model, on main fact table we can get the product inovoice(InvoiceNo) wise sale. Now on another table(Shippment) we can find the CommercialInvoiceNo linked with main fact table by OrderId and InvoiceNo(Composite key). Now for some InvoiceNo, Commercial Invoice No is null. So I have to create a flag on the basis of InvoiceNo, i.e. If CommercialInvoiceNo is null on the basis of InvoiceNo then product is not shipped else shipped.By these logic ship status flag will be created. So anyone have any solution then share.

[MK_QSL]

What is the common field in both table? ShipKey?

Unclear from you explanation as your explained fields are not matching with your example field.

[alexandros17]

Here it is

[koushik_btech20]

Sorry friends I have provided the wrong example qvw application. Providing the actual qvw example file where in Shipment table there are no balnk commercial invoice no. Now we have to create the flag(shipstatus). ShipKey is the common field.

[alexandros17]

Take a look to the document ...

Hope it helps