Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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  ??

Tags (2)
3 Replies
swuehl
Not applicable

How to calculate field in script after joining two tables

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
Not applicable

How to calculate field in script after joining two tables

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

How to calculate field in script after joining two tables

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