Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ,
I'm having below scenario:
Were these KT-PartNo belongs to Plant codes highlighted after # in location filed
What I want to have is output like below , so that I can assign Location codes for KT-PartNo:
Please suggest how to do this???
Thanks,
AS
Try,
Table:
LOAD * Where len(Trim(New_Location))>0;
LOAD *, Keepchar(Subfield(Location,'#'),0123456789) as New_Location
Inline [
KT-PartNo, Location, PartFamily
72681 ,ABC#099 KT Holzlar HQ+PTF#008 KT Mallersdorf#098 KT Small-series production, unassigned
74257 ,ABC#008 KT Mallersdorf#012 KT Bohemia Fuel#099 KT Holzlar HQ+PTF ,unassigned
76620 ,ABC#008 KT Mallersdorf, unassigned
79051 ,ABC#010 KT Tessenderlo#007 KT Leer ,unassigned
];