A suppliers inventory file that needs to be modified to my exact store file in order to update

%3CLINGO-SUB%20id%3D%22lingo-sub-2509679%22%20slang%3D%22en-US%22%3EA%20suppliers%20inventory%20file%20that%20needs%20to%20be%20modified%20to%20my%20exact%20store%20file%20in%20order%20to%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2509679%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20will%20soon%20find%20out%26nbsp%3B%20I'm%20a%20complete%20newbie%20to%20Excel.%20I%20have%20been%20tossed%20into%20the%20deep%20end.%20Here%20is%20what%20I'm%20trying%20to%20accomplish.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.)%20I%20have%20a%20supplier%20who%20has%20granted%20me%20access%20to%20their%20sftp%20server%20in%20order%20to%20have%20access%20to%20an%20inventory%20update%20file%20that%20is%20updated%20every%202%20hours.%20I%20will%20be%20downloading%20this%20file%20twice%20a%20day%20(for%20now)%20for%20the%20updated%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.)%20I%20need%20to%20update%20my%20file%20that%20I%20download%20for%20my%20store%20with%20the%20updated%20supplier%20inventory%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.)%20Each%20(my%20inventory%20and%20my%20supplier%20inventory)%20file%20has%20different%20information%20some%20which%20I%20need%20and%20some%20that%20I%20do%20not.%20(%20once%20I%20have%20downloaded%20my%20supplier%20file%20can%20I%20setup%20Excel%20to%20remove%20those%20columns%20of%20data%20that%20is%20not%20needed%20and%20to%20leave%20what%26nbsp%3B%20I%20do%20need.%20(%20Maybe%20a%20script%20or%20action%20etcc)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eproblem%3A%20The%20updated%20file%20that%20will%20be%20uploaded%20to%20my%20store%20MUST%20be%20formatted%20and%20must%20contain%20the%20exact%20data%20(just%20updated)%20exactly%20as%20it%20is%20when%20it%20was%20downloaded.%20otherwise%20Im%20told%20it%20will%20fail.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4.)%20I%20must%20do%20this%20atleast%20twice%20a%20day%20untill%20I%20can%20have%20it%20run%20and%20update%20on%20its%20own%20some%20how..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20headache%20just%20writing%20it%20out.%26nbsp%3B%20Sorry%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanx%20for%20atleast%20looking%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2509679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2509906%22%20slang%3D%22en-US%22%3ERe%3A%20A%20suppliers%20inventory%20file%20that%20needs%20to%20be%20modified%20to%20my%20exact%20store%20file%20in%20order%20to%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2509906%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1093735%22%20target%3D%22_blank%22%3E%40tapanrack01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eafter%20some%20investigating%20I%20came%20across%20power%20queries%2C%20I%20believe%20this%20may%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Everyone,

 

As you will soon find out  I'm a complete newbie to Excel. I have been tossed into the deep end. Here is what I'm trying to accomplish.

 

1.) I have a supplier who has granted me access to their sftp server in order to have access to an inventory update file that is updated every 2 hours. I will be downloading this file twice a day (for now) for the updated data.

 

2.) I need to update my file that I download for my store with the updated supplier inventory data.

 

3.) Each (my inventory and my supplier inventory) file has different information some which I need and some that I do not. ( once I have downloaded my supplier file can I setup Excel to remove those columns of data that is not needed and to leave what  I do need. ( Maybe a script or action etcc) 

 

problem: The updated file that will be uploaded to my store MUST be formatted and must contain the exact data (just updated) exactly as it is when it was downloaded. otherwise Im told it will fail. 

 

4.) I must do this atleast twice a day untill I can have it run and update on its own some how..

 

I have a headache just writing it out.  Sorry

 

Thanx for atleast looking

 

 

1 Reply

@tapanrack01 

 

after some investigating I came across power queries, I believe this may help