Skip records in BPC Transaction data load

[former_member302840]

Hi Experts,

I am trying to skip Accounts starts with numbers other than 1.

I am using the following code in BPC Transformation file.

Method 1:

Transformation ACCT = *IF(ZGACT(1:1)=*STR(1) then ZGACT; *STR(ACT_NONE))

Conversion ACT_NONE *SKIP()

In this approach, Accounts are loading to the Model with ID as ACT_NONE

Method 2: Transformation ACCT = *IF(ZGACT(1:1)=*STR(1) then ZGACT; *STR(NACT)+ZGACT)

Conversion NACT* *SKIP()

This approach is also not working.

I think the Accounts are getting loading before execute the conversion file.

can any one help me the way to skip the records in BPC Transaction data load. I am not getting any issue with Master data load with the above type of formulaws. but when we load the transaction data, it is comparing the Master data so getting the issue.

[former_member186338]

Please show full conversion file screenshot!

[benniejayfguevarra]

Hi Vara,

It should be just *SKIP in the conversion file.

Regards,

Bennie

[former_member302840]

Hi Bennie,

that was a mistake, I sued () in my query.

I used only *SKIP in the conversion file.

Eg: I used correct Conversion NACT* *SKIP

[benniejayfguevarra]

Hi Vara,

You can try something like below.

Transformation

ACCT= ZGACT

CONVERSION

Thanks,

Bennie