Forum Discussion
Merging and appending multiple files using the Data Tab
Use Case: I receive 7 data files (csv and Excel), from various suppliers, in various formats. I clean the data through Power Query into the same column headers. I now need to combine these files/tabl...
1. Duplicate SKU's can't exist in the same table.
2. The product ID is Unique for every line item, and is typically allocated within the ecommerce platform on upload.
3. Unfortunately I can't break the file down, as it has taken on a life of it's own over the month, with many hundreds of dependencies.
2. The product ID is Unique for every line item, and is typically allocated within the ecommerce platform on upload.
3. Unfortunately I can't break the file down, as it has taken on a life of it's own over the month, with many hundreds of dependencies.
- Duplicate SKU's can't exist in the same table
OK - The product ID is Unique for every line item
That doesn't help me understand I'm afraid. Does 'line item' mean SKU? - Unfortunately I can't break the file down
??? In an effort to help you I created 3 tables (attached) with dummy data (took +/- 15 mins, no more...). Are they representative of your scenario/context? If not please reshape, fill them & share the file so we have something realistic to work with. Thanks
- That is the kindest thing anyone has done for me all week, thank you, thank you, thank you.
You have it exactly.
Is there a way to filter it by SKU and Lowest cost per SKU, so that I only publish a single SKU in the SKU Column?Merged table1-3 and added it to data model
created power pivot table
Set the value to Min of Price
See attached
Is there a way to filter it by SKU and Lowest cost per SKU, so that I only publish a single SKU in the SKU Column?
Not sure I understand... So take a look at the Output tab in the attached file. If this doesn't do what you expect please post a picture showing SKU100 (I changed values) as you'd like it to be
