Deduplication Operation in Data Table

Help Studio
1

What can I do to deduplicate cells that are the same in a particular column in the data table?

For example ; A column of 10 rows reads 5 rows A and 5 rows B . I want to deduplicate 1 A and 1 B and write them into a new data table.

…

Veri tablosundaki belirli bir sütunda aynı olan hücreleri tekilleştirmek için ne yapabilirim?

Örneğin ; 10 satırlık bir kolonun 5 satırında A ve 5 satırında B yazıyor . Tekilleme yaparak 1 A ve 1 B alıp bunları yeni bir veri tablosuna yazmak istiyorum.

2

Hi @Huseyin_Kizil ,

Could you maybe provide us with a Visual Representation of the Input and Output Data, we can be clear of the requirement in that manner and suggest you the correct approach.

It seems that a filtration needs to be done, but we are not sure if the filtration is to be done based on the values or the number of rows.

3

I want to deduplicate for the same data deduplicating to a column in a data table. I want to write all the cells with different names into a different data table. As a result of my studies, I wrote my codes as follows ;

DataTableName.AsDataView.ToTable(True,“ColonName”)

Now , The deduplication is done correctly.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.