How to make operations and create new fields in database.

[#1]

Dear All.

Im a rookie in qlik view development, so ineed to make and operation in the script i dont know how to do it.

In my project i have three excel documents, with three tables, my idea is to make operations in the script between fields of the different excel documents and with the result obtain create a new field in DB.

Somebody can help me with my doubt?

BR

[Gysbert_Wassenaar]

If you want to do calculations using fields from different tables (created from different excel files) then you need to create a table that contains all the fields needed for the calculation. Usually this is done by joining these tables using the JOIN keyword.

[settu_periasamy]

Hi,

May be the below link will give the understanding to Load the Multiple Excel Sheets and Files..

Load all Excel files and all sheets in a folder

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[#4]

Hi,

You have to LOAD all the Excels you need. You can do these from the Script Editor --> Plain Files.

For Example

ExcelTable:

LOAD *

from C:\Excelfile.xls (xls);

Depends on the content of each Excel you will need to concatenate on ExcelTable the other xls or create one table per xls.

Hope I'm useful.

Regards,