Hi All,
Thanks for reading my post.
I have a requirement in which file format is as given below
Account|Category|Time|RptCurrency|Amount|Quantity
I am able to upload Amount into my application, I need to update Quantity into another account. I have tried options using *NEWCOL(A) with combinations of with and without Header file format. In case of without header my Transformation is as following:
============================================================
*OPTIONS
FORMAT = DELIMITED
HEADER = NO
DELIMITER =
SKIP = 0
SKIPIF =
CREDITNEGATIVE=NO
VALIDATE_RECORDS=YES
*MAPPING
ACCOUNT = *COL(1)
CATEGORY = *COL(2)
DATASRC = *COL(3)
ENTITY = *COL(4)
RPTCURRENCY = *COL(5)
Time=*COL(6)
AMOUNT=*COL(7)
*CONVERSION
============================================================
I need to add another Mapping to read the Quantity coming in the file but moment I do that, BPC Transformation reports error that Account dimension is already mapped and in second case when I have two columns in the file with Header, Data manager reports error "DUPLICATE SIGNEDDATA"
I may end up having another dimension to store quantity, will appreciate your comments which can be give me some hints to fix this issue.
Regards,
Umesh