You didn't say what platform you were using. If its java based you can
probably use a java hash table to store the counter of the pallet and put each
line into the new group you create based on that counter. Otherwise a sort.
On Jan 31, 2012, at 3:41 AM, Vijay chandra Kola wrote:
>
>
> 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]
>
>
[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/
