Chris.JamesPye |
Newbie |
|
UK |
|
|
None Specified |
|
Thursday, December 13, 2018 |
Tuesday, January 22, 2019 10:36:10 AM |
3 [0.02% of all post / 0.00 posts per day] |
|
Great thank you
|
Hi,
My apologies please see attached.
I only want one row based on the Carrier, Rate Type, Equipment, Charge Code
Many Thanks Chris
|
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
|
|