Transformation File from Flat File Validation Error: Command error: NEWCOL(

[Former Member]

Hi,

I am trying to create a transformation file to update 2 Accounts from one source file.

Tansfromation file in Screen shot and source file also attached.

MVAL syntax is wrong, if i use MKEY it giving total ACCOUNTHR as error.

Regards,

Tej

Source Data.txt.zip

[former_member186338 · Accepted solution]

Hi Tej,

To my mind the formula you have is OK but with MKEY:

ACCOUNTHR=*MKEY(Position_Hrs|*NEWCOL(NO_HRS)||No_Days|*NEWCOL(NO_DAYS))

TAB delimiter is critical!

DELIMITER = TAB

Vadim

[Former Member · Accepted solution]

Hi Vadim and JP

My file is CSV format and my transformation file is also having "," as separator.

If i want to use the same transformation file with only updating single Key Figure like

ACCOUNTHR = *STR(No_Days)

It is working fine.

Even below code is working fine

ACCOUNTHR = MVAL(No_Days|*STR(NO_DAYS))

But when i try to update 2 key figures it gives error as shown in the screenshot.

I will try to replicate with MKEY and send the screenshot.

Thanks for your reply.

[former_member186338 · Accepted solution]

Your attached Source Data.txt is 100% TAB delimited. If  you use another file - please show it...

Vadim

[former_member186338 · Accepted solution]

P.S. Read http://service.sap.com/sap/support/notes/1944359

[former_member186338 · Accepted solution]

May be:

ACCOUNTHR=*MVAL(Position_Hrs|*STR(NO_HRS)||No_Days|*STR(NO_DAYS))

P.S. Read also: http://service.sap.com/sap/support/notes/2105374

[Former Member · Accepted solution]

Hi Vadim,

Need your clarification:

If i use NO_DAYS as Account ID and updated in Transformation file.

System is giving error Error: Command error: NEWCOL(

I have changed the Account ID as FTE_days or anything Other than NO_DAYS, and updated tranformation file accordingly --> NO ERROR.

Can you please confirm me are there any RESERVE words that we cannot use in ACCOUNT ID?

Here is my Account Dimension as an attachment and Transformation file and Uplaod results,  all file you require.

My Dimension File and Source file as CSV format, as SCN is not allowing me to attach CSV file, i have converted then to TXT.

If i use MVAL only system is working, MKEY system is giving below error

Regards,

Tej

Source Data.txt.zip

ACCOUNTHR.txt.zip

[former_member186338 · Accepted solution]

Hi Tej,

It was the note that you can't use NEWCOL with already existing ID case insensitive (No_Days and NO_DAYS). And forget about MKEY

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Correct me if i am wrong.

If we are creating Transforamtion rule ensure that we dont have same Coloum name in sournce field and Destination field.

In my Case Sournce Column name is No_Days and Account ID is NO_DAYS, So error.

I have tested my changing Source field with FTE_DAYS/Fte_Days and Account ID as FTE_DAYS , system gave the error.

When i revert the changes Source as No_Days and Account ID as FTE_DAYS, no Error.

Thanks for your help.

Regards,

Tej

[former_member186338 · Accepted solution]

Hi Tej,

I have already metioned: http://service.sap.com/sap/support/notes/2105374

Please read it!

In CPMBPC 800 SP16 / CPMBPC 801 SP09 / CPMBPC 810 SP05 it's fixed.

Vadim

[Former Member]

Hi Tej,

Try with this formula:

Accounthr=*MKEY(Positions_hr|*NEWCOL(No_HR)||No_days|*NEWCOL(NO_DAYS))

Corrected with syntax and spaces. Let me know it it works...

Also your txt file is with TAB delimiter whereas your transformation file suggests "," as delimiter.

Regards,

JP