I have Infopath file where I am showing Repeating table from SQL. I need hide duplicate rows (Where ID column comes twice). I have managed to do this. But when I am getting count of Table rows, its giving total count i.e. including duplicate one.
How can I count this unique entries that are displayed?
Ultimate goal is ot create pagination using this count.