Group multiple accounts into one account

former_member606751 · ‎2020 Feb 26

Hi Experts,

I'd like to know if it's possible to groupe multiple accounts into one account using the conversion file.

I used the following schema :

External Internal

62100000 6160000

62300000 6160000

62400000 6160000

When I validate my transformation file, BPC returns an error. The account "6160000" is not a single ID

Any advice ?

Best regards

former_member186338 · ‎2020 Feb 26

If you chain is /CPMB/IMPORT_IOBJ_MASTER then I am completely lost on what are you doing!

This chain is used to load member ID's and properties (MASTER data).

With your conversion file you are trying to load ID 6160000 multiple times! Absolutely strange idea!

You have to *SKIP member ID's you don't want to load.

If you decide to load TRANSACTIONAL data then this conversion file will work.

former_member606751 · ‎2020 Feb 26

My package is :

My transformation file is :

Prompts are following :

Hope it will help you

Regards

former_member606751 · ‎2020 Feb 26

For example :

When I try to execute my package, I got an error : ID 61600000 is non unique

I thought BPC would understand when i write 6160000 in internal column it would group 0000021000, 00000031000, 00000037000 into 6160000 account.