Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate field in script after joining two tables

Can someone explain to me how to calculate a field in the script from two fields in a table that is the result of left-joining to load statements?

Here is the simplified script

Tab1:

Load

     CustomerName,

     InvoiceDate,

     InvoiceValueEuro

From file1

Left Join Load

     InvoiceDate,

     ExchangeRate

From file2

What is the next step to add to this table the field InvoiceValueUSD=InvoiceValueEuro*ExchangeRate  ??

4 Replies
swuehl
MVP
MVP

A simple approach would be a resident load (or store to and load from a qvd) with adding the new field:

Result:

LOAD *, InvoiceValueEuro*ExchangeRate as InvoiceValueUSD

Resident Tab1;

drop table Tab1;

swuehl
MVP
MVP

Or you could do a Mapping Load of your Exchangerate table first,

then use applymap function in creation of your new field while loading your value table.

Not applicable
Author

Thanks a lot for both answers. I have tried both solutions, and each works fine.

saradhakishore
Contributor
Contributor

Hi I have a similar query .i need to create a new table and the majority of the fields in this table are derived from a calculation based on couple of other resident table fields . how should i mention it in the script .please help