Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA solution to last week's challenge has been posted here!
This week's challenge was submitted by @pawel_zych - thank you for your contribution!
This is a Supply Chain Management challenge. Your task is to generate the Negotiation file for Category Managers that they can use while negotiating new prices with the Suppliers. Match each PN with prior Supplier Names and APV. Create one column that indicates a case where there was more than one Supplier in the historical data.
Great practice concatenating and blending to kick off the week!
I have a feeling it can be done in fewer tools