Thank you Selva
for the response. But the data is too huge to be handled by Excel, thus I
need to do it with hive.
On Thu, Oct 10, 2013 at 2:31 PM, Selvamohan Neethiraj <
selva.apa...@infotekies.com> wrote:
> If it is not so much data, you can use Excel's PivotTable to solve this
> specific req
If it is not so much data, you can use Excel's PivotTable to solve this specific requirement:1. Select the date and plz columns (w/o header) and create pivotTable on a new WorkSheet2. Drag the column name: 'Date' from the 'Pivot Table' Builder to the 'Column Label' section.3. Drag the column name:
Hello,
I have a data manipulation query.
I have my data in the following format:
*Date PLZ Count*
date1 plz1 count1
date1 plz1 count2
date1 plz1 count3
date1 plz2 count4
date1 plz2 count5
date1 plz3 count6
date1 plz3 count7
date2 plz1 count8
date2 plz1 co
