IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Distinct Rows Options · View
Chris.JamesPye
Posted: Thursday, December 13, 2018 3:02:48 PM
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
island
Posted: Friday, December 14, 2018 7:19:17 AM
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)
Chris.JamesPye
Posted: Friday, December 14, 2018 9:30:42 AM
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
K101
Posted: Wednesday, January 2, 2019 1:36:19 PM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 558
In that case, you should use group-by as demonstrated by the attached example.

File Attachment(s):
example.mfd (18kb) downloaded 325 time(s).


Chris.JamesPye
Posted: Tuesday, January 22, 2019 10:36:09 AM
Rank: Newbie

Joined: 12/13/2018
Posts: 3
Location: UK
Great thank you
Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.