Forum Discussion
Vba To power querry
Don't waste your time trying to convert from one system (philosophy) to another (also called "fighting the API"). Please provide sample data in usable format (not as a picture) , show the expected outcome, and give sufficient context of what you are trying to achieve.
Hello, many thanks for your attention.
Please download the excel:
Imagine, I am a seller who wants to sell my products (Table 1 - My Products). So, I will analyze sales by category and I will try to exchange products sold to mine according to the following rules.
the rules is:
Switching between products in table 1 - my products for the sales table according to the rules
Exchange the sale product for my products if:
- Exchange made in the sales table. According to the rules, make sales exchanges for my products. It has to be in the same category
- "Price Limit - The price of the product that I will make the switch does not exceed one euro more"
- The profitability of the product that I will trade must have a profitability greater than or equal
- if it is a product in the table my products do not switch
- If the chances of exchange have the same profitability, the tiebreaker is for the price. Whoever has the smallest price difference for the sale price is chosen. However, if the products for exchange have the same profitability and the price difference is the same, the product with the lowest price is chosen.
Any doubt is just to say. Many many thanks
