Dear all,
I am trrying to do it myself, but I can't get it done.
I am trying to create a seperate path for people that are inside of someone else path.
I have 2 datasets:
1. Dataset contains Leads and their paths
2. Contains only paths (which are of people in the background=
Dataset 1 | Result | ||
Lead | Path | Path | |
LLL | ABC|123|XXX|ZSA | ABC|123|XXX|ZSA|LLL|U82 | |
XXX | 512|A5G|7GH | 512|A5G|7GH|XXX|ZSA | |
Dataset 2 | |||
Path | |||
ABC|123|XXX|ZSA | |||
LFA|532|ZZZ|LLL|U82 | |||
025|6AF|3DK|E8S |
Basicly I want to check each row 1 by 1 from Dataset 1 within all of Dataset 2 if I can find the Lead from Dataset 1 inside the Path of Dataset 2 and do some stuff and append the reults below each other after some formulas to get to the result.
I already have the workflow build to get to the result, but I can't get it working to check each row 1 by 1 from Dataset 1.
This is probably a Batch Macro stuff but I am new to macros and can't get it to work at all.
Solved! Go to Solution.
@binuacs That actually might work as well... I might have been thinking to hard... need to test it with the real data.
But still, just in terms of learning.
How do I manage to do it via a Batch Macro where I take each row from Dataset 1 on its own to run trough a workflow.
I can't manage to do it myself yet.
@binuacs Okay - so I think I get how the Batch Macro works - that was my main goal to solve the problem before you gave me a workaround.
Nevertheless I have a time issue cause its taking really long in both cases with the BatchMacro taking even longer than the workaround because of the amount of rows I have.
Is there any idea you might have to do it another way and reduce the time that I have generating the appended fields?
If not, no worries - I am just trying to think if its possible to make it faster
Actually both of the following filters are taking even longer because of the amount of rows generated.
Any idea? :)