topic Re: How do you add a column to a table created from two other tables in QlikView

How do you add a column to a table created from two other tables

adurgani — Wed, 11 Apr 2018 17:39:32 GMT

How would you add a column to BLI? BLI is a table created from a cross table and a straight table in two different tabs on an excel sheet.

We need to concatenate Month and Dimension.

jerifortune — Wed, 11 Apr 2018 17:47:41 GMT

Try this

Load *, Year & Month AS YearMonth;
Load *
From BLI

adurgani — Wed, 11 Apr 2018 17:52:53 GMT

I still get an error - Its something rudimentary that I'm missing.

Cannot open file '\\............MyDocs\Qlikview Reports and Data\BLI' The system cannot find the file specified.

Load *

From BLI

jerifortune — Wed, 11 Apr 2018 18:01:54 GMT

I used the script as an example

Your load script should remain the same. Only add Load *, Year & Month AS YearMonth; at the top of the BLI load statement as shown below

Example

BLI:

Load *, Year & Month AS YearMonth;

Load

FID,

Month,

BLI

adurgani — Wed, 11 Apr 2018 18:37:16 GMT

The issue is that one of the fields that I need to concatenate is created using crosstable:

Dimension Jan Feb Mar

BLI1 10 20 30

Crosstable

Dimension Month Amount

BLI1 Jan 10

jerifortune — Wed, 11 Apr 2018 18:44:37 GMT

The first step is to unpivot the table

Then use Concatenate to join the two tables Or add the values from the two tables after joining by YearMonth