HomeForum
Welcome, Guest

Sorter
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Sorter

Sorter 2 years, 1 month ago #836

  • rudolfsun
  • OFFLINE
  • Junior Boarder
  • Posts: 33
  • Karma: 0
Hi

Im trying to use the sorter in a transformation, but keep receiving the error 'Field order duplicate found'.

I am trying to sort on an unique and Im appending an access table to an Oracle table.

Thanks

Emile

Re:Sorter 2 years, 1 month ago #838

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
If you are sorting just on one field set for this field \"Field Order\" to 1

\"Field Order\" allows to sort on multiple fields.

For example if you want to sort by Product name first than by Sales Amount

Tick sort for Product Name and Sales Amount fields
Than set \"Field Order\" to 1 for Product Name and \"Field Order\" to 2 for Sales Amount

Please let us know the outcome,
Mike
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

We Process 3000 files daily, 24h x 365d

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top