I have an input file with 2 columns (id, type), for the same id we can end up with the same type, like this:
id = 1 -> type = 'A'
id = 2 -> type = 'C'
id = 1 -> type = 'A'
id = 1 -> type = 'A'
id = 3 -> type = 'H'
id = 5 -> type = 'K'
id = 1 -> type = 'E'
.
.
.
And so on
So there is a management rule that says that:
for a type equal to 'A' return '300'. If a second type = 'A' exists for the same id return 301. If a third type = 'A' exists for the same id return 302, ... so on. kind like a sequence
I already started using the taggregateRow component to group on id and type and I add a 3rd column to the taggregateRow component output that counts the number of tpye for an id, and then I do not know too much I will continue
it will be really nice if someone can help me the top
