BPC Transformation File - skip a column

[Former Member]

Hi Experts,

I have an upload file I want to upload to 2 differebt models, 1 with less dimensions.

How can I just skip a column of the upload file?

*MAPPING

ACCOUNT = YBOACCOUN

AUDITTRAIL = *NEWCOL(Input_Excel)

CATEGORY = *NEWCOL(Actual)

ENTITY =YBOPLAWER

TIME = TIME

YREFKUNDE = YBOREFKUN

DATAGROUP = YBODATTYP

YPLANT = YBOABGWER

YMATERIAL = YBOMATERI

RPTCURRENCY = YBOUNIT

YKUNDBEZ = YKUNDBEZ

YSDVERTRE = YSDVERTRE

YPCTRNEW = *SKIPCOL

I just want to skip or ignore the last column? What is the correct command for the transformation file? *SKIPCOL and 'SKIP so not work...

Many thanks in advance!

Sandra

[former_member186338 · Accepted solution]

Simply remove this line:

YPCTRNEW = *SKIPCOL

P.S. The mapping depends on the left side of the mapping equation. If you remove the whole line the system will not even look on last column

[Former Member]

Thanks!!!

Worked 😉

[Former Member]

Hi Sandra ,

No Clarity ... Are you aware of Data Loading TR Mapping ...?

If you have N Dimensions in your Model then You must give some TR values for each of this N Dimensions....

Here in your case you said

For .e.g. you have 3 Dim in Model 1 & you have 4 Dim in Model 2

In your flat file you have 4 Columns(1,2,3,4)...!

For Model-1 Mapping

1 Dim = Col-1

2 Dim = Col-2

3 Dim = Col-3

For Model-2 Mapping

1 Dim = Col-1

2 Dim = Col-2

3 Dim = Col-3

4 Dim = Col-4

So the system will automatically SKIP Column-4 for Model-1............

No need to mention any special function if the Model don't have the Dimension

Aravind