locked
Two 2.5GB sales data files RRS feed

  • Question

  • Hi,

     

    I have 2 text files, each about 2.5GB for 2009 and 2010 sales data.

     

    How can I can combine them so that they both appear in the same tab, and thus the same pivottable? When I try to import, I get 2 tabs, one for each year, and can’t find a way to create one pivot table combining both tabs.

     

    Thanks Neil

    Thursday, March 17, 2011 2:34 PM

Answers

All replies

  • How about importing them to one same SQL table? Then use SQL Server as source.
    -- This posting is provided "AS IS" with no warranties, and confers no rights
    Friday, March 25, 2011 6:16 AM
  • If your aware to load data by using SQL Server as source your can do it.

    Other wise, you can merge both the tables in one sheet as follows

    Steps: Hopping both text files data having identical colums

    1) First load your text files individually to PowerPivot, these text files would create 2 separate tabes for each year data

    2) Select your tab1 data and  Copy your tab 1 to clipboard( ctrl+c)

    3) once to select data and press ctrl+c, the past Options enabled

    4) select "past into new table"...paste here ur first tab data

    5) Now select second tab data and copy to clip board(Ctrl+c)

    6) go to Newly created table

    7)  Click on past options and select "Past to append new rows"

    8) Press ok.

    9) Data will merged in one sheet

    10) Done

     

    Hope this helps...

    Regards,

    gopal


    Business intelligence
    Friday, March 25, 2011 8:27 AM
  • May be another option, load both text files in 2 seperate execl files and follow the steps as described on next url http://blog.contextures.com/archives/2010/09/06/powerpivot-from-identical-excel-files/
    Eddy N.
    • Marked as answer by Jerry Nee Sunday, April 10, 2011 2:57 AM
    Friday, March 25, 2011 9:00 AM