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.
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.