subtract 2 lists.

[Macs Bank]

Does anyone have a simple example they can show me with how to take 2 different lists (or a tables) and subtract them from each other to get a unique record only?

For example, I have a main list of URLS and I select a random URL from the first list (but not delete it) and once I finish doing a process with that URL, it gets added to the second list. Then, when the template restarts, I want to be able to select a unique record from list 1 that is not found in list 2.

I would greatly appreciate the help!

 

[bigcajones]

Something like this?

 

[Macs Bank]

thanks for the fast response!!

I'm not sure if that is exactly what I was looking for... it might be -- I guess I need to play around with it a little more to see if it works...

But basically, the process would be similar to having a list of proxies that you load and that you only want to use 1 time, but not delete from the original list. would you use a similar template above to do that?

 

[bigcajones]

If you only want to use them one time in a run then delete them and add them to end of list at end of template. If you only want to use them once ever, delete them from list and add to a second list.

 

[Macs Bank]

yeah, deleting it from the first list and adding it to a second list would work, but then when I run out of records in list 1, I would have to re-add everything from the second list to the first list... right?

 

[bigcajones]

Yes of course, but you can always delete it and add it to the end for each run.

 

[Macs Bank]

ok cool. thanks again for your help!