General

Re: Count unique values from a secondary source (sharepoint)

toren78 — Tue, 04 Dec 2012 05:49:16 GMT

Jimmy,

Imagine the entire Internet giving you a standing ovation right now,

It worked!

Thank you,

Oren

Re: Count unique values from a secondary source (sharepoint)

Jimmy — Mon, 03 Dec 2012 16:54:57 GMT

I see a potential issue in the formula. Please try this:

count(xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings[not(@MA = preceding-sibling::dfs:meetings/@MA)])

Re: Count unique values from a secondary source (sharepoint)

toren78 — Mon, 03 Dec 2012 16:33:27 GMT

Yes, there are many MA values which are the same,

The requirement is to count only those unique MA records.

Re: Count unique values from a secondary source (sharepoint)

Jimmy — Mon, 03 Dec 2012 16:29:27 GMT

Is there any chance there were two records with the same MA value?

Re: Count unique values from a secondary source (sharepoint)

toren78 — Mon, 03 Dec 2012 13:58:36 GMT

Hi,

This time there was no error, but the it counted all the records save for one, i.e there are 3206 records and the count was 3205.

Any ideas?

Cheers,

Oren

Re: Count unique values from a secondary source (sharepoint)

Jimmy — Mon, 03 Dec 2012 04:46:22 GMT

Please give this a try:

count(xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings[@MA != preceding-sibling::dfs:meetings/@MA])

Re: Count unique values from a secondary source (sharepoint)

toren78 — Mon, 03 Dec 2012 04:40:13 GMT

Sure: I tried either: count(xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings/@MA[. != preceding-sibling::xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings/@MA]) Or: count(xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings[@MA != preceding-sibling::xdXDocument:GetDom("Meetings")/dfs:myFields/dfs:dataFields/dfs:meetings/@MA]) Thank you

Re: Count unique values from a secondary source (sharepoint)

Jimmy — Mon, 03 Dec 2012 04:00:40 GMT

Could you post the actual formula you wound up with?

Re: Count unique values from a secondary source (sharepoint)

toren78 — Sun, 02 Dec 2012 10:34:08 GMT

Hi, The suggested method did not work. I'm getting an error that a "Node test" was expected. Also, since it is a secondary source, Infopath added this prefix to the Xpath: xdDocument:GetDom ("source name")/dfs:...... Are you able to help? Oren

Re: Count unique values from a secondary source (sharepoint)

toren78 — Thu, 29 Nov 2012 15:56:48 GMT

Jimmy, Thank you for your swift reply! I'll test it Sunday first thing and report back, Cheers, Oren

Re: Count unique values from a secondary source (sharepoint)

Jimmy — Thu, 29 Nov 2012 15:02:57 GMT

The general format would be this:

count(repeatingGroup[field != preceding-sibling::repeatingGroup/field])

Count unique values from a secondary source (sharepoint)

toren78 — Thu, 29 Nov 2012 14:38:05 GMT

I have a secondary source in Infopath 2007 filler form template, This source is from a Sharepoint list that contains many records. my requirement is to count unique records (text) in one of the columns. Example: Col a A A A B B D Should count 3. Searched all over the place but could not find a proper solution... Ideas? Thanks, Oren.