Hi.

I would like to see an option such as 'Move Duplicates to another Data Grid' within the 'Remove Duplicates from Data Grid'action.

Sometimes there may be data in other cells of the current row that are unique, moving the whole row rather than deleting, could allow for further comparison using the 'Compare Grids' action.

Thanks

You can also add an extra column with a hash of the columns you find important for uniqueness.
Then remove the duplicates on the hash column.

Tijn

.....Sorry Tijn, I don't quite understand what you mean.

Tom

See my example post:
http://www.djuggler.com/tabid/632/a...fault.aspx

Thanks for the example Tijn. That example works well if you want to test the uniqueness of a whole row/column or group of cells. In my situation I wanted to test for whether or not there were any duplicate numbers in a column. If there were, ALL of the matching rows would need to be moved to a new spreadsheet, rather than anything being deleted at all. I used the 'Find in Data Grid' action to locate these matches and move the rows....not difficult, but a single action such as 'Move Duplicates' or rather 'Move all Matching' would just reduce the script lines a little.

Согласен, было бы здорово, если можно было бы дубли скопировать в другой Data Grid в рамках того же действия 'Remove Duplicates from Data Grid'.

А каким образом возможно сейчас скопировать дубли в другой "Data Grid" подскажите, пожалуйста?

In English please?

How you can copy from DataGrid1 only doubles in DataGrid2?
Sorry for the english - translate http://translate.google.com
Thank you.

See the action Compare Grids in the advanced Data Grid Section.

That action does exactly what you describe.

As I understand, "Compare Grids" compares DataGrid1 and DataGrid2 and the result deduces in DataGrid3.
I need to Compare a line in one column DataGrid1 and doubles to write down in DataGrid2.


Tried through a cycle:
Variable i - the counter of cells. Starting value = 1
1. The variable n appropriates value i cells
2. The variable m appropriates value i+1 cells.
3. Values of variables are compared.
Further i = i+1 and the cycle repeats.
But (!) it is impossible to specify the Variable in the action "Get Data Cell Value".

You understand me?

Please help me

See my example post in the community forum.

http://www.djuggler.com/tabid/632/a...fault.aspx

Thank you very much, Tijn!