Data Extraction & Creating relationships in excel file

[Mohanss82]

I have an excel dump with 150 columns and 50K rows generated from system every day from which I just require 30 columns every day. Similarly I have a foreign key in this file to be compared for relationship with 3 more files with 50K rows. I wanted to create a relationship for all 4 files and apply power pivot on them so that I can refresh and get the required details. Most importantly we need the pivot file should be under small size, so that we can access it whenever required. Attached is the layout. Please advise.

 

[Dan Bliss]

If you are facile with SQL or MS Access, I would load this into a database.

 

[BBMB]

If you are facile with SQL or MS Access, I would load this into a database.

I second this. MS Access with SQL works wonders. You can still use Excel as the front-end if you want, but you are much better off making use of Access' database features when possible.