I am trying to Validate & Process Transformation File against my Data file I am getting the error message that I have at the below. When I validate the Conversion files, I see the creation of corresponding .CDM files. I even deleted the .CDM files and recreated the files.
So my question is why it is giving "Sheet does not exist (CONVERSION)" warning for which it is rejecting the records inside the Data File?
DATA FILE:
******************************
C_Category,Time,R_ACCT,R_Entity,InputCurrency,Amount
ACTUAL,2007.DEC,AVG,GLOBAL,USD,1
ACTUAL,2007.DEC,END,GLOBAL,USD,1
ACTUAL,2007.DEC,AVG,GLOBAL,JPY,110
ACTUAL,2007.DEC,END,GLOBAL,JPY,110
ACTUAL,2007.DEC,HIST,GLOBAL,JPY,110
ACTUAL,2007.DEC,HIST,GLOBAL,USD,1
ACTUAL,2008.MAR,AVG,GLOBAL,USD,1
ACTUAL,2008.MAR,END,GLOBAL,USD,1
ACTUAL,2008.MAR,AVG,GLOBAL,JPY,107.5
ACTUAL,2008.MAR,END,GLOBAL,JPY,105
ACTUAL,2008.MAR,HIST,GLOBAL,JPY,110
ACTUAL,2008.MAR,HIST,GLOBAL,USD,1
TRANSFORMATION FILE:
*********************
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT=
SPECIFICMAPPING=YES
*MAPPING
C_Category=*col(1)
Time=*col(2)
R_ACCT =*col(3)
R_Entity=*col(4)
InputCurrency=*col(5)
Amount=*col(6)
*CONVERSION
C_Category=[COMPANY]C_Category.xls!CONVERSION
Time=[COMPANY]Time.xls!CONVERSION
R_ACCT=[COMPANY]R_ACCT.xls!CONVERSION
R_Entity=[COMPANY]R_Entity.xls!CONVERSION
InputCurrency=[COMPANY]InputCurrency.xls!CONVERSION
ERROR
********************************
[Start validating transformation file]
Validating transformation file format
Validating optionsu2026
Validation on options was successful
Validating mappingsu2026
Validation on mappings was successful
Validating conversionsu2026
Sheet does not exist (CONVERSION)
Sheet does not exist (CONVERSION)
Sheet does not exist (CONVERSION)
Sheet does not exist (CONVERSION)
Sheet does not exist (CONVERSION)
Validation on conversions was successful
Creating the transformation xml file; wait a moment
Transformation xml file saved successfully
Connecting to server...
Begin validate transformation file with data fileu2026
[Start test transformation file]
Validate has successfully completed
ValidateRecords = YES
Task name CONVERT:
No 1 Round:
Record count: 12
Accept count: 0
Reject count: 12
Skip count: 0
Error: All records are rejected