General

Re: Randomizer

erzon — Thu, 01 Oct 2020 11:33:47 GMT

thanks at least I made you laugh in any way :) thanks again until next time

Re: Randomizer

Hilary Stoupa — Thu, 01 Oct 2020 00:03:18 GMT

Oh wow, I'm still laughing over that reply (and I REALLY NEEDED to laugh today) so thanks! Glad it is working :)

Re: Randomizer

erzon — Wed, 30 Sep 2020 23:11:52 GMT

thank you so much works like a charm :). I want to eat your brain lol you're so good with this thank you

Re: Randomizer

Hilary Stoupa — Wed, 30 Sep 2020 22:43:08 GMT

You just have to use the same XPath but with your fields? Maybe: xdXDocument:GetDOM("random date")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Loan_x0020_number[not(. = xdXDocument:GetDOM("Randomizer")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:LOans)]

Re: Randomizer

erzon — Wed, 30 Sep 2020 22:38:40 GMT

got your sample but how can I modify this to my datasource? using "random date" and "randomizer"?

Re: Randomizer

Hilary Stoupa — Wed, 30 Sep 2020 22:24:59 GMT

Attaching a sample.

Re: Randomizer

erzon — Wed, 30 Sep 2020 21:57:39 GMT

Hilary Stoupa:
So - the issue is that by default, with XPath, you are going to get back the first "non-match" every time. Is that going to be acceptable?

yes correct as long its not match whatever rows it is that would be ok

Re: Randomizer

Hilary Stoupa — Wed, 30 Sep 2020 21:52:24 GMT

So - the issue is that by default, with XPath, you are going to get back the first "non-match" every time. Is that going to be acceptable?

Re: Randomizer

erzon — Wed, 30 Sep 2020 20:50:49 GMT

Hilary Stoupa:
Both of the data sources have multiple rows? "random dates" and "Randomizer"? The XPath I gave you returns true if there are no matches between the lists, and false if there are matches. I'm sorry I'm having such a hard time understanding what you are trying to do here. Can you try to describe it a bit more? Like: One list has values A,B,C,D. The other list has values E,B,D,A. I want to get back "C" from the first list because it doesn't exist in the second list. Or whatever the actual scenario is.

Yes the two data source have multiple rows. Your scenario actually is correct. If the "random dates" have A,B,C,D,E,F,G,H coupon and the "randomizer" have A,B,D,E,F coupon already and the only remaining is C,G and H then the field can either pick C or G or H

Re: Randomizer

Hilary Stoupa — Wed, 30 Sep 2020 20:33:59 GMT

Both of the data sources have multiple rows? "random dates" and "Randomizer"? The XPath I gave you returns true if there are no matches between the lists, and false if there are matches. I'm sorry I'm having such a hard time understanding what you are trying to do here. Can you try to describe it a bit more? Like: One list has values A,B,C,D. The other list has values E,B,D,A. I want to get back "C" from the first list because it doesn't exist in the second list. Or whatever the actual scenario is.

Re: Randomizer

erzon — Wed, 30 Sep 2020 20:20:30 GMT

yes there are multiple rows in the coupon that is why I want the logic will scan all the rows and check if that coupon exist in main list is that possible?

Re: Randomizer

Hilary Stoupa — Wed, 30 Sep 2020 20:08:09 GMT

Sorry, yeah, that is just going to return true and false. So - are there multiple rows in both data sources? Because if so, you'll always get the first coupon code from the random date data source....

Re: Randomizer

erzon — Wed, 30 Sep 2020 20:00:37 GMT

I tried your xpath and the result shows "false" instead of the coupon code

Re: Randomizer

Hilary Stoupa — Wed, 30 Sep 2020 19:54:02 GMT

If you want to see if there is no match in "random date" based on Loan_x0020_number equaling LOans, I'd try:

not(xdXDocument:GetDOM("random date")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Loan_x0020_number[. = xdXDocument:GetDOM("Randomizer")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:LOans])

Re: Randomizer

erzon — Wed, 30 Sep 2020 15:12:24 GMT

Sorry but our network prohibit us to upload anything but your understanding is correct. I just need to check if the coupon is already exist from other data source list

my logic here is like this xdXDocument:GetDOM("random date")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Loan_x0020_number[xdXDocument:GetDOM("Randomizer")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:LOans != .]

the results of this is always showing same coupon code even it exist in the other data source