What about flattening your data structure and indexing these as separate documents, is that a possibility? e.g.
{
playerId: 123,
firstName: "John",
lastName: "Doe",
clubName: "Bayern",
status: "active",
position: "goal keeper"
}
{
playerId: 123,
firstName: "John",
lastName: "Doe",
clubName: "Manchester United",
status: "inactive",
position: "defense"
}
I think that would be easier to work with in Kibana.