Mapping Through Excel (Resposted)

Thu, 28 Nov 2013 10:54:29 GMT

Hello:

I have a script that gives four fields namely,

Company,

Profit Center,

Account,

Amount

I would like to create an excel file where another filed is created called as "Classification",

so that users can create classifications to which the Amount should fall into.

For example (scenario as to how it will look in Excel) :

Company Profit Center Account Classification (User input field)

01 20000 Sales

01 30000 Sales
02 Sales

03 5050 COS

04 PPV

and so on....

The combination top arrive at the Classification could be any possible one between the

Company, Profit Center and Account.

The list of Company, Profit Center and Account combination is huge and runs into thousands of lines.

And QV will read off this Excel file to make a table based on the Classification entered

by the user.

Is this possible, appreciate any help in this matter

thanks

Kumar

topic Mapping Through Excel (Resposted) in QlikView