Filtering changing examples

ga34hox

Hallo everybody

 

i got a data set with about 200000 rows und i want to use a specific filter.

Example:

Row1    Old   Name1

Row2   New  Name1

Row3   Old   Name2

Row4   New  Name2

Row5   Old   Name1

Row6   New Name3

Row7  Old  Name3

Row8  New Name3

 

A filter operator (or an other) shall filter by "Name1". If this Name changes (here: to "Name3" in Row6) the filter should filter by "Name3" and so on. Finally i wanna have all the rows (In this case: Row 1,2,5,6,7 and 8). In the end the whole data set should be grouped.

Anybody an idea? Thank you so much. 

Regards ga41hox

kypexin

Hi @ga34hox

 

Aggregate operator seems to be the closest to the task you need to accomplish.

Though I didn't quite understand how exactly your output should like at the end?

ga34hox

Hi @kypexin

thanks for your reply.

I got some tools in my data set where each has a specific "name" (notation). But over time the name changes (in this example: "Name1" to "Name3"). In the end i wanna have all the names (notations) the specific tool have ever had till this day. My data set is full of different tools with changing names. The data set schould be grouped by tools. In the upper example there would be two groups (First: Row1,2,5,6,7,8 ; Second: Row3,4).

I hope you can understand.

Regards ga34hox

Telcontar120

It sounds like Aggregate should do the job.  You may need to use "Lag" first to detect when the name changes and then generate a flag for that, and then use that along with the name.