how to extract all rows with samen "Key" from matrix

Hi all, I am trying to extract from a Large Matrix with almost 70000 elements all rows with the SOURCE_KEY (column 3 of the matrix) '1BY6WEcLGh8j5v7' so that only the values to the matching KEY remain.

Does anyone have any ideas?

Answer 1

[patrick1704]

Your SOURCE_KEY column is a categorical. Thus, you just have to do something like this:

reducedData = Electricity(Electricity.SOURCE_KEY == categorical({'1BY6WEcLGh8j5v7'}), :)

[Simon Kant]

THX!! It wroks :)