Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Left join in different tabs

I have a table from excel in one tab in the script and another is a SQL statement from database in another tab.

I want to left join both of them. How do I do it?

So the one from excel has below kind of data.

CodeQuarterdata
XXCY2014 - Q1200
XXCY2014 - Q4200
YYCY2014 - Q1200
YYCY2014 - Q4200
ssCY2014 - Q1200
ssCY2014 - Q4200
ZZCY2014 - Q1200
ZZCY2014 - Q4200

The one from database SQL has lot of columns with Fis Quarter(it is of same format as Quarter from excel,but is kind of master quarter data)as one of the columns. I want to left join "Quarter" of excel to "Fis Quarter" of my SQL statement.

So finally my data should have

Code | Quarter | data | column1 from sql | column2 from Sql | etc.....

1 Reply
maxgro
MVP
MVP

pseudo-code

// from excel

Table:

load

     Code,

     Quarter,

     data

from

     .......;

// join with sql data

left join (Table)

load

     FisQuarter as Quarter,

     .....

     ;

SQL

select

     FisQuarter,

     .......

from

     .......;