topic How to make operations and create new fields in database. in QlikView

How to make operations and create new fields in database.

Thu, 05 Nov 2015 16:45:05 GMT

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?

Re: How to make operations and create new fields in database.

Gysbert_Wassenaar — Thu, 05 Nov 2015 16:59:01 GMT

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.

Re: How to make operations and create new fields in database.

settu_periasamy — Fri, 06 Nov 2015 02:42:33 GMT

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

Re: How to make operations and create new fields in database.

Mon, 01 Feb 2016 18:15:51 GMT

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,