InfoPath Dev

Hi, Please share a technique to get a unique values from rom repeating table (secondary data source) With this rule I getting all values from table: xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Electrical_requisiton_Drawings")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Drawing_No, 'concat(., ";")'), "..")

I've attached a sample - right click and save locally, right click, select design and preview. Add some rows to the repeating table, and set some of the fields to the same value. For your formula, I'd try: xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Electrical_requisiton_Drawings")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[not(d:Drawing_No = preceding-sibling::d:SharePointListItem_RW/d:Drawing_No], 'concat(d:Drawing_No, ";")'), "..")

Thank you very much Hilary! One more little problem is all values from table is setting to field. I need only Drawing_no field to be there (marked with yellow). I don't need a cable tag to be there. xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Electrical_requisiton_Drawings")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[not(d:Drawing_No = preceding-sibling::d:SharePointListItem_RW/d:Drawing_No)], 'concat(., ";")'), "..")

You missed my change to the concat piece of the formula: 'concat(d:Drawing_No, ";")'), "..")

My mistake! Thank you very much Hilary!!!