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

[adurgani]

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]

Try this

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

[adurgani]

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]

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]

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]

The first step is to unpivot the table

Find how to unpivot the table here
https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/LoadData/work-with-cross-tabl...

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