topic Re: Left join in different tabs in QlikView

Left join in different tabs

Thu, 30 Oct 2014 00:29:50 GMT

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.

Code	Quarter	data
XX	CY2014 - Q1	200
XX	CY2014 - Q4	200
YY	CY2014 - Q1	200
YY	CY2014 - Q4	200
ss	CY2014 - Q1	200
ss	CY2014 - Q4	200
ZZ	CY2014 - Q1	200
ZZ	CY2014 - Q4	200

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

Re: Left join in different tabs

maxgro — Thu, 30 Oct 2014 00:40:45 GMT

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

.......;