|
Rank: Newbie
Joined: 12/13/2018 Posts: 3 Location: UK
|
Hi All,
Hoping you can help please see below:
Carrier Rate Type Origin Market Origin Country Origin Place Name Origin Dest Market Dest Country Destination Place Name Dest Eff.From Eff.To Equipment Currency Lump Sum Charge Code Charge Name Charge Description Commodity Charge Basis Comments 1 Transit Time Principal Client Name Consignee Consignee Name Consignor Consignor Name Agent Agent Name Movement.Terms Client Type/Group Port Origin Port Dest Carrier2 Carrier Name Clearance Agent Clearance Agent2 Maximum Sailing Schedule Department Supplier Analysis Charge Filt3 Analysis Charge Filt MAR fak 40HC USD 103 oce-ebaf CONTAINER MAR fak 40HC USD 83 oce-lsc CONTAINER MAR fak 40HC EUR 12 oce-dhc CONTAINER MAR fak 40HC EUR 67 oce-dcf CONTAINER MAR fak 40HC USD 103 oce-ebaf CONTAINER MAR fak 40HC USD 83 oce-lsc CONTAINER MAR fak 40HC EUR 12 oce-dhc CONTAINER MAR fak 40HC EUR 67 oce-dcf CONTAINER MAR fak 40HC USD 103 oce-ebaf CONTAINER MAR fak 40HC USD 83 oce-lsc CONTAINER MAR fak 40HC GBP 12 oce-dhc CONTAINER MAR fak 40HC GBP 67 oce-dcf CONTAINER MAR fak 40HC USD 103 oce-ebaf CONTAINER MAR fak 40HC USD 83 oce-lsc CONTAINER MAR fak 40HC EUR 12 oce-dhc CONTAINER MAR fak 40HC EUR 67 oce-dcf CONTAINER
As you can see a number of the rows are duplicated. So would like to just return one charge code or row per Carrier, Rate Type and Equipment can some please give me some advice on how I can achieve this?
So what I would like is: MAR fak 40HC USD 103 oce-ebaf CONTAINER MAR fak 40HC USD 83 oce-lsc CONTAINER MAR fak 40HC EUR 12 oce-dhc CONTAINER MAR fak 40HC EUR 67 oce-dcf CONTAINER
Many thanks in advance Chris
|
|
Rank: Newbie
Joined: 10/28/2002 Posts: 1,283 Location: AT
|
Hi,
I assume that this is supposed to be the header of the file:
Code: Carrier Rate Type Origin Market Origin Country Origin Place Name Origin Dest Market Dest Country Destination Place Name Dest Eff.From Eff.To Equipment Currency Lump Sum Charge Code Charge Name Charge Description Commodity Charge Basis Comments 1 Transit Time Principal Client Name Consignee Consignee Name Consignor Consignor Name Agent Agent Name Movement.Terms Client Type/Group Port Origin Port Dest Carrier2 Carrier Name Clearance Agent Clearance Agent2 Maximum Sailing Schedule Department Supplier Analysis Charge Filt3 Analysis Charge Filt
and these are the values corresponding to the headers:
Code: MAR fak 40HC USD 103 oce-ebaf CONTAINER
seeing as both are space delimited this would infer that "Mar" is a Carrier, "fak" is a Rate, "40hc" is a Type, "USD" is an Origin, "103" is a Market, "oce-ebaf" is another "Origin" (???) and "CONTAINER" is a country.
This doesn't make sense. Please CLARIFY WHICH HEADER each of these values is supposed to correspond to.......
(It may help if you attach the source file you are dealing with. You can attach the file by first POSTING a response and then using the Attachments button)
|
|
Rank: Newbie
Joined: 12/13/2018 Posts: 3 Location: UK
|
Hi,
My apologies please see attached.
I only want one row based on the Carrier, Rate Type, Equipment, Charge Code
Many Thanks Chris
|
|
Rank: Advanced Member
Joined: 2/27/2009 Posts: 565
|
In that case, you should use group-by as demonstrated by the attached example. File Attachment(s): example.mfd (18kb) downloaded 328 time(s).
|
|
Rank: Newbie
Joined: 12/13/2018 Posts: 3 Location: UK
|
Great thank you
|
|
guest |