When trying to import data into controller from a flat file using a lookup table with duplicates (i.e. two or more source accounts into a single destination) I get this message:
"A lookupo table defined to have duplicates cannot be used within operations templates connected to a field in Fields 1"
Pinned topic Cannot import data using lookup table with duplicates.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-04T17:03:39Z at 2012-06-04T17:03:39Z by SystemAdmin
SystemAdmin 110000D4XK41 Posts
Re: Cannot import data using lookup table with duplicates.2012-06-04T17:03:39ZThis is the accepted answer. This is the accepted answer.Accounts in the "from" part of the lookup table must be unique. If you use one account code in the "to" column, the balances of the "from" accounts will be added up into the "to" account.