Problem when use Mapping with RowNo() for Input fields

Sun, 04 Dec 2011 17:01:44 GMT

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 — Sun, 04 Dec 2011 18:08:17 GMT

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?

topic Problem when use Mapping with RowNo() for Input fields in QlikView