Hi All,
I am struck at a scenario where i need to group items that have same pallet#.
Both Pallet# and Item UPC fields are in the same record(i.e. item record of my
flat file).
Flat file sample:
pallet_1 Item_1_UPC
pallet_1 Item_2_UPC
pallet_1 Item_3_UPC
Pallet_2 Item_4_UPC
Pallet_2 Item_5_UPC
Pallet_3 Item_6_UPC
Pallet_1 Item_7_UPC
Pallet_1 Item_8_UPC
Desired EDI output:
MAN*GM*Pallet_1
LIN****Item_1_UPC
LIN****Item_2_UPC
LIN****Item_3_UPC
LIN****Item_7_UPC
LIN****Item_8_UPC
MAN*GM*Pallet_2
LIN****Item_4_UPC
LIN****Item_5_UPC
MAN*GM*Pallet_3
LIN****Item_6_UPC
I am able to group items that come under successive Pallet#. But the problem is
when the Pallet# is repeated somewhere in the input(not successive), I couldn't
able to group them under same Pallet#.
Can anyone please advice.
Regards.
[Non-text portions of this message have been removed]
------------------------------------
...
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Job postings are welcome, but for job postings or requests for work: <JOBS> IS
REQUIRED in the subject line as a prefix.Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/EDI-L/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
