Hi, I'm facing some difficulties to find the right tool to have the desired output as per shared below: My Input Data: PLANTORIGINCOUNTRYNO_CONVEYANCEPAPT2A1ASOUTH AFRICA154556PAPFQDEAPEOPLES REP OF CHINA154556PAPGBJWCTHAILAND1000040PAPGBJWCTHAILAND1004794PAPCPZPASOUTH AFRICA1028858PAPT2A1ASOUTH AFRICA1028858BCMLA3264BPEOPLES REP OF CHINA1033690PAP0132AGERMANY1034104PAPGSDTPPEOPLES REP OF CHINA1034117SBC0134DGERMANY1034762PAPHB13AINDIA1036024PAPDA4WDINDIA1036024PAPAHVFAINDIA1036024PAPGBJWCTHAILAND10403PAPT2A1ASOUTH AFRICA1042814BCMLAGMP5AMEXICO1050137BCMLA1688DINDIA15046PAPCPZPASOUTH AFRICA15046PAPFQDEAPEOPLES REP OF CHINA1506284PAPAX9WASOUTH AFRICA1508477PAPGBJWCTHAILAND1514695 Desired Output: PLANTORIGINCOUNTRYNO_CONVEYANCEPAPGBJWCTHAILAND1000040PAPGBJWCTHAILAND1004794BCMLA3264BPEOPLES REP OF CHINA1033690PAP0132AGERMANY1034104PAPGSDTPPEOPLES REP OF CHINA1034117SBC0134DGERMANY1034762PAPGBJWCTHAILAND10403PAPT2A1ASOUTH AFRICA1042814BCMLAGMP5AMEXICO1050137PAPFQDEAPEOPLES REP OF CHINA1506284PAPAX9WASOUTH AFRICA1508477PAPGBJWCTHAILAND1514695 Basically, eliminate all duplicated values on field "NO_CONVEYANCE" and keep the rest. Many thanks for the support!! Eduardo

How to achieve desired Output below

Hi,

I'm facing some difficulties to find the right tool to have the desired output as per shared below:

My Input Data:

PLANT	ORIGIN	COUNTRY	NO_CONVEYANCE
PAP	T2A1A	SOUTH AFRICA	154556
PAP	FQDEA	PEOPLES REP OF CHINA	154556
PAP	GBJWC	THAILAND	1000040
PAP	GBJWC	THAILAND	1004794
PAP	CPZPA	SOUTH AFRICA	1028858
PAP	T2A1A	SOUTH AFRICA	1028858
BCMLA	3264B	PEOPLES REP OF CHINA	1033690
PAP	0132A	GERMANY	1034104
PAP	GSDTP	PEOPLES REP OF CHINA	1034117
SBC	0134D	GERMANY	1034762
PAP	HB13A	INDIA	1036024
PAP	DA4WD	INDIA	1036024
PAP	AHVFA	INDIA	1036024
PAP	GBJWC	THAILAND	10403
PAP	T2A1A	SOUTH AFRICA	1042814
BCMLA	GMP5A	MEXICO	1050137
BCMLA	1688D	INDIA	15046
PAP	CPZPA	SOUTH AFRICA	15046
PAP	FQDEA	PEOPLES REP OF CHINA	1506284
PAP	AX9WA	SOUTH AFRICA	1508477
PAP	GBJWC	THAILAND	1514695

Desired Output:

PLANT	ORIGIN	COUNTRY	NO_CONVEYANCE
PAP	GBJWC	THAILAND	1000040
PAP	GBJWC	THAILAND	1004794
BCMLA	3264B	PEOPLES REP OF CHINA	1033690
PAP	0132A	GERMANY	1034104
PAP	GSDTP	PEOPLES REP OF CHINA	1034117
SBC	0134D	GERMANY	1034762
PAP	GBJWC	THAILAND	10403
PAP	T2A1A	SOUTH AFRICA	1042814
BCMLA	GMP5A	MEXICO	1050137
PAP	FQDEA	PEOPLES REP OF CHINA	1506284
PAP	AX9WA	SOUTH AFRICA	1508477
PAP	GBJWC	THAILAND	1514695

Basically, eliminate all duplicated values on field "NO_CONVEYANCE" and keep the rest.

Many thanks for the support!!

Eduardo

Datasets

Accepted answers

Kenda

@Edu This is exactly what the Only Unique tool does.

Here is a link so you can download the CReW macros: http://www.chaosreignswithin.com/p/macros.html. There are a lot in there that you might find useful in other cases as well.

If you do not wish to download those, you could alternatively use the normal Unique tool then add a Join after it, joining the U and D outputs on the [NO_CONVEYANCE] field. Then just keep the L output.

All comments

Kenda

Hey @Edu!

Do you have the CReW macros installed? I think the Only Unique tool is just what you're looking for here!

Edu

Hi @BarnesK,

Thanks for your prompt feedback and support.

I do not have macros installed. I tried to use Unique tool, but I would want to bring only the values on field "NO_CONVEYANCE" that never repeat. Those values that repeat, eliminate all. Unique tool eliminate duplicated values but return keeping one of them. Should I use another tool?

Thank you again

Kenda

@Edu This is exactly what the Only Unique tool does.

Here is a link so you can download the CReW macros: http://www.chaosreignswithin.com/p/macros.html. There are a lot in there that you might find useful in other cases as well.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335