Filtering changing examples

ga34hox
ga34hox New Altair Community Member
edited November 2024 in Community Q&A

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

Answers

  • kypexin
    kypexin New Altair Community Member

    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
    ga34hox New Altair Community Member

    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
    Telcontar120 New Altair Community Member

    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.