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"
This topic has been locked.
1 reply Latest Post - 2012-06-04T17:03:39Z by SystemAdmin
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 PostsACCEPTED ANSWER
Re: Cannot import data using lookup table with duplicates.2012-06-04T17:03:39Z in response to SystemAdminAccounts 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.