Hi All,
Could you please assist me how to replace below code with pick match.
CONCATENATE ([Order Delivery Days])
LOAD *,
Dual (If ([Delivery Difference Days] > 0,
If ([Delivery Difference Days] <= 5, 'Week or Less',
If ([Delivery Difference Days] <= 10, 'Two Weeks or Less',
If ([Delivery Difference Days] <= 20, 'Month or Less',
If ([Delivery Difference Days] <= 40, 'Two Months or Less', 'Over Two Months'))))),
If ([Delivery Difference Days] > 0,
If ([Delivery Difference Days] <= 5, 1,
If ([Delivery Difference Days] <= 10, 2,
If ([Delivery Difference Days] <= 20, 3,
If ([Delivery Difference Days] <= 40, 4, 5)))))) as [Late Status];
CONCATENATE ([Order Delivery Days])
and
If ([Order Delivery Status by Calculated GI Date] = 'On Time', [Order Delivery Status by Calculated GI Date],
If (Floor ([Planned Delivery Date]) <= Floor ([Sales Document Creation Date]), '1. Bad First Date',
If ([%Plant_PLANT] = 'US09', '2. US09 Plant - Springfield',
If (Floor ([Planned Delivery Date]) = Floor ([Sales Document Creation Date] + 1), '3. ATP Error',
If (Match ([%Item category_ITEM_CATEG], 'ZTAG', 'ZTSG', 'ZTAC', 'ZTAK', 'ZTBG', 'ZTL1', 'ZTL4', 'ZTLK', 'ZTRO', 'ZLBX') AND Floor ([Production Order Delivery Date]) > Floor ([Planned Delivery Date]), '4. Manufacture to Order',
If (Floor ([Actual Goods Issue Date]) >= Floor ([Planned Delivery Date]) AND Floor ([Delivery Document Creation Date]) <= Floor ([Planned Delivery Date]), '5. Warehouse Issue',
If (Match ([%Item category_ITEM_CATEG], 'ZTAP', 'ZTAB') > 0 AND Floor ([Latest Purchase Order Goods Received Date]) > Floor ([Planned Delivery Date]), '6. Vendor',
If (Match ([%Item category_ITEM_CATEG], 'ZTAS', 'ZUCS', 'ZTCS', 'ZTBS', 'ZLKF', 'ZSAS', 'ZSST'), '7. Drop Shipment',
If (Match ([%Item category_ITEM_CATEG], 'ZTNN', 'ZANN'), '8. Stock Items',
If ([Domestic/Export] = 'Export', '9. Export Order', '10. Other')))))))))) as [Late Analysis]