Extract without duplicated data

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

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.