Dear Experts, Which tool and condition, logic need to use to get the required output?
Input | ||||||
Category | Set | Item Type | Ex Type | Quantity | Available Position | Ageing |
MY DATA | MY-1 | SP | PSS | 400000 | 400000 | 60 |
Difference Quantity | 400,000.000 | |||||
MY DATA | MY-1 | LP | BP | 50000 | 50000 | 39 |
MY DATA | MY-1 | SP | BP | 50100 | 50000 | 39 |
Difference Quantity | 100.000 |
Output | ||||||||
MY DATA | MY-1 | SP | PSS | 400000 | 400000 | 60 | Difference Quantity | 400,000.000 |
MY DATA | MY-1 | LP | PB | 50000 | 50000 | 39 | Difference Quantity | 100.000 |
MY DATA | MY-1 | SP | PB | 50100 | 50000 | 39 | Difference Quantity | 100.000 |
Solved! Go to Solution.
You can achieve the below with the helps of tools Multirow formula, Filter and then Join.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
@ShankerV - But while Joining back the data - am not getting correct values. Can you please share the workflow?
Please find the expected output.
Input was:
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Step 1: Input
Step 2:
Step 3:
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Hi @ravikumar060987 .
Step 4:
Step 5:
Step 6:
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
Step 7: Join tool
Last step: Browse tool to show the output
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V