Hi all,
I have a scenario where I need to filter the data from sql tables with the list of materials input given in the excel file.
User will browse the excel for the list of materials for the input and runs the workflow. Then the workflow pulls the data from the sql tables and filter for the materials provided in the input file and gives the output.
We should show the status as two categories in the output file.
1. Materials having values in one measurement column or in all measurement columns should be given as 'active material'.
Here the measurement columns are Quantity, Receipts etc. ---- >> Implemented...
2. Materials that do not have any values in all dimension columns will not exist in the sql table. So, the user should add these materials present in the input to the output and give the status as 'Inactive materials'. ---- >> To be Implemented. Need help on this on How to?.
I'm trying to find the output for the below materials. User includes the list of materials that he wanted to look for in the excel file and browse this file using browse macro tool. Attached excel file has the below materials included.
| 7101746 |
| 7101747 |
| 7151799 |
| 7151802 |
| 7169256 |
| 7256000 |
| 7200678 |
| 7250601 |
| 7201445 |
| 7201444 |
| 7201220 |
But, I get the output of only one material which is 7256000 from the sql table which is Active. You could see the output of sql table in the Input file. I now need other materials to be shown as Inactive in the Status column.
I've built a part of workflow where it only gives the output of Active materials for the materials that have the data in sql tables. How do we show the output now for the materials that do not have the values in the sql tables (which means the output should be shown for all the materials provided in the user input).
It'd be great if you can check and help me..
Thank you.
Best regards,
Teja.
