Forum Discussion
ryan_b_fiting
Post Patron
Post PatronCombining Files from Folder that have differnt Headings
Hello Community -
I have a bit of an urgent issue. I have a file in my Sharepoint folder that I am connected to that the columns are shown below (but go all the way thru March 2020):
Geography Product Week Ending 03-31-19 Week Ending 04-07-19 Week Ending 04-14-19
I am adding a new file to the folder with the recent dates (April 2020) and the column headers do not match up so I am unable to combine the files currently. Is there an easy solution for this so that I can combine the files whenever a new one is loaded to the folder without having to do anything manually?
Thanks for your help everyone!
Ryan F
5 Replies
- Mariusz
Community Champion
You can Unpivot all your Week Ending columns, this would create two columns instead Attributes with eg. Week Ending 04-07-19 text as row value + Value Column with a relevant Value.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
ryan_b_fitingI have tried this already, and unfortunately this does not work for me. If I unpivot prior to promoting the first row to headers, the week ending dates show up in the values column with other values. But if I unpivot after promoting the headers, the when I try to update the data I get an error combining the files.I have attached a screen shot and a sample set of data for what the data looks like.Thanks for the help!Geography Product Dollar Sales Dollar Sales Dollar Sales Dollar Sales Unit Sales Unit Sales Unit Sales Unit Sales Dollars per Store Selling Dollars per Store Selling Dollars per Store Selling Dollars per Store Selling Total Points of Distribution Total Points of Distribution Total Points of Distribution Total Points of Distribution Geography Product Week Ending 03-29-20 Week Ending 04-05-20 Week Ending 04-12-20 Week Ending 04-19-20 Week Ending 03-29-20 Week Ending 04-05-20 Week Ending 04-12-20 Week Ending 04-19-20 Week Ending 03-29-20 Week Ending 04-05-20 Week Ending 04-12-20 Week Ending 04-19-20 Week Ending 03-29-20 Week Ending 04-05-20 Week Ending 04-12-20 Week Ending 04-19-20 Region 1 Product1 9819.86 9419.13 9367.74 9538.39 1971 1889 1879 1912 13.69576011 13.19205882 13.02884562 13.24776389 72.69637991 72.20123021 71.8599083 72.19654174 Region 2 Product2 238.12 231.63 139.36 93.89 90 85 47 29 5.411818182 6.095526316 4.805517241 4.082173913 3.891725086 3.423465341 2.72354627 2.010795215 Region 1 Product3 4715.43 4421.56 4649.28 5050.8 961 901 944 1016 8.913856333 9.005213849 9.469002037 9.584060721 55.13808465 51.34822785 51.01005635 55.61746743 Region 1 Product4 165.28 164.59 102.29 70.5 64 64 36 26 4.349473684 5.1434375 5.383684211 4.147058824 3.338173872 2.654928211 1.687045772 1.356103879 Region 2 Product5 2.19 1 2.19 0.11950019 Region 1 Product6 6912.75 6300.08 5648.68 7061.43 1390 1263 1132 1475 11.0604 9.984278922 9.755924007 10.58685157 64.07610891 63.86441458 59.33892165 67.01302874 Region 2 Product7 7246.49 6666.64 5968.04 7780.79 1453 1336 1196 1619 10.6722975 10.35192547 10.01348993 11.16325681 68.73475877 65.12172628 60.04153046 70.60619282 Region 1 Product8 5056.68 4854.03 4605.77 5200.77 1017 975 923 1085 9.434104478 9.263416031 9.267142857 9.812773585 56.55013807 55.05129971 52.2670337 55.58772427 Region 1 Product9 5818.38 5001.5 5134.71 6794.63 1171 1005 1029 1423 9.553990148 9.044303797 8.883581315 10.50174652 62.02081412 56.1767622 59.20313442 65.52898394 Region 2 Product10 5260.49 5184.61 4486.01 5817.74 1058 1039 899 1228 9.564527273 9.358501805 8.796098039 9.459739837 57.42449636 57.92245468 53.82233428 64.14734983
- Greg_Deckler
