How to automatically modify members in Conversion file in BPC

[former_member966825]

We load Headcount data from Work day . Work day file has columns for location and cost center.

We are doing a conversion for location. For specific set of cost centers, we want the location to be a specific value (L_DL).

We want to override the original location value, how can we do this using Conversion file while loading data using data manager package.

[former_member186338]

Please, provide full info, including data sample and expected results sample!

[former_member186338]

Looks like you are loading transaction data!

There is no simple way to load 2 records from one original line with one value.

Only routine badi can add lines.

What do you mean by "specific set"? What is the criteria?

In general you can copy data after loading using script logic from US to L_DL

[former_member966825]

Hi Kalinin,

We are loading Flat file with Employee details ( Employee id , Cost center , Location , Role , Status , Data src , Rpt currency ) .

Ex:For example if we get the transaction as below :

Employee id = EMP_01

Cost center - CC_9009

Location = US

We are expecting to create two records with the help of Conversion file

Records 1:

Employee id = EMP_01

Cost center - CC_9009

Location = US

Record 2:

Employee id = EMP_01

Cost center - CC_9009

Location = L_DL

Is there a way / logic available to do with help of conversion file.