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.....