Problem when use Mapping with RowNo() for Input fields

[#1]

Hello,

I'm trying to mapping the Input Fields with the following script:

Directory;

INPUTFIELD BR_Code_IOC_Code, Branch_Number;

branchMap:

MAPPING

LOAD BR_Code_IOC_Code,

     Branch_Number

FROM

branchMap.xlsx

(ooxml, embedded labels, table is Sheet1);

Map BR_Number using branchMap;

LOAD GL_Code,

     InsideOutside_Country_Indicator,

     Branch_Code,

     Cost_Center_Code,

     Branch_Code&Cost_Center_Code&InsideOutside_Country_Indicator AS BR_Number,

       Amount_in_Country_Reporting_Currency,

     Snapshot_Date

FROM

[GGL Table.xlsx]

(ooxml, embedded labels, table is Sheet1)

Unfortunately, there is an error "MAPPING requires 2-column input"

I tried to delete RowNo() statement, and it works.

Seem like I cant use function Mapping with RowNo() for Input fields.

Don't know how to fix it.

Anybody can help me ??

[swuehl]

pattarav.s,

I am a bit confused:

- where have you placed your rowno() function, I can't find it in your script?

- I believe the mapping table won't exist anymore after your script execution, so why do you use INPUTFIELD on fields in the mapping table?

- if you say it works, it works in what way, what is your expectation here?