Hello all!
Hope you're all doing well.
I've recently started using Power Query in Excel to pull in data from my ODBC connection, but I'm a little stuck on how I would implement a report I am trying to create and was wondering if the awesome people here would be able to point me in the right direction!
I have a query that pulls Stock Information like below:
I want to add a column to this table which includes 'Stock Alerts' - these alerts will be held in another table where a user can enter a Stock Code, Group, Type and Category along with a message pertaining to those stock items.
E.G.:
I'm struggling to find a way to match these especially as some lines will have more relevancy than others.
Hopefully I've made what I'm trying to achieve clear!
I understand that this forum isn't a 'do this for me' kind of forum, but if anyone has any pointers or tips, it would be really appreciated. I have tried searching for how to do this, but I've also struggled to find any information!
Kind regards,
B
Hope you're all doing well.
I've recently started using Power Query in Excel to pull in data from my ODBC connection, but I'm a little stuck on how I would implement a report I am trying to create and was wondering if the awesome people here would be able to point me in the right direction!
I have a query that pulls Stock Information like below:
Stock Code | Group | Type | Category |
---|---|---|---|
CAPXSQU12 | RLI | CXS | |
CAPZSQU13 | RLI | CZS | |
CARSWE69 | ICL | ECO | |
CARSWE74 | ICL | ECO | |
CARSWE91 | ICL | ECO | |
CASACR4MM | SPM | NEO | |
CASACRMMN | SPN | NEO | |
CDAPSAEDG111 | LAN | FEN | DEP |
CDAPSAEDG111 | LAN | FEN | DEO |
I want to add a column to this table which includes 'Stock Alerts' - these alerts will be held in another table where a user can enter a Stock Code, Group, Type and Category along with a message pertaining to those stock items.
E.G.:
Stock Code | Group | Type | Category | Stock Alert |
---|---|---|---|---|
CDAPSAEDG111 | Check colour is 'black' not 'black ash' | |||
RLI | All Products in 'RLI' group have a 10% discount | |||
RLI | CZS | There is currently a 5 day wait on RLI/CZS Products | ||
DEP | Free Delivery on any products in 'DEP' Category |
I'm struggling to find a way to match these especially as some lines will have more relevancy than others.
Hopefully I've made what I'm trying to achieve clear!
I understand that this forum isn't a 'do this for me' kind of forum, but if anyone has any pointers or tips, it would be really appreciated. I have tried searching for how to do this, but I've also struggled to find any information!
Kind regards,
B