Skip to main content

Extract without duplicated data

Hi All,
Can you help or guid me to extract without duplicated data  ? 
column A (character type ):
1  
2
1
4
5
1
3
Thanks.

Brian Element Tue, 10/10/2017 - 11:33

HI Ahmed,

For this are you only interested in the first time an item shows up or in items that only appear once.  So do you want something like:

1

2

4

5

3

or

2

4

5

6

3

So the first one would only shoe the first time the 1 shows and all the others as they appear only once.

Thanks

Brian

Ahmed Tue, 10/10/2017 - 11:50

Hi Brian,
like this 
1
2
4
5
3
Thank you.

Brian Element Tue, 10/10/2017 - 12:26

Hi Ahmed,

Try doing a summarization on the field you only want one of.  Then click on fields and make sure all the fields are selected and then select Use fields from first occurrence.  This way you will get all the information from the first transaction for each key.

Ahmed Wed, 10/11/2017 - 03:55

Hi Brian,
Great; it works,
Thank you.
Ps: How can I modify to have the choice to select between "Use fields from first occurence or from last occurence"  ? because as you can see it in the snapshot they don't give me the choice.

Brian Element Wed, 10/11/2017 - 05:42

In reply to by Ahmed

Hi Ahmed,

That means that you didn't select any fields.  So click on the fields button (probably Champ for the French version) and select one or more fields, if you want the entire first or last transaction then select all.  Once you have selected one or more fields then you should have the option to select the first or last field.

Thanks

Brian

Ahmed Wed, 10/11/2017 - 06:32

Hi Brian
Yes this is why, and now it's okay,
Thank you for your helping.

The website encountered an unexpected error. Try again later.