Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Code | Quarter | data | column1 from sql | column2 from Sql | etc.....
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
.......;