Omit data from a table

[Luisanabria]

Hi all

I have this table in my field "Category 1" l want omit "Service", "Administrative", from my table with all the information, how can l do it?

I think about Set Analysis but I dont know exactly how

hope can help me 

Thanks all

[luiferva]

Hola Fdoflogtz1

Podrias utilizar un where en tu script de la siguiente forma

T:
LOAD
Categoria1
FROM
[..\..\..\xtabla.xlsx]
(ooxml, embedded labels, table is Above)  where not Match(Categoria1,'Servicio','Administrativo');

el not match significa en lenguaje natural, por favor carga todos los registros de Categoria1 pero no quiero que cargues 'Servicio','Administrativo', el nombre de los registros debe ser tal cual no es lo mismo 'Servicio' que 'servicio' 

Reagalame un like para saber si logre ayudarte, si tienes dudas, no dudes en preguntar

Luis Vallejo.

[Luisanabria]

Hola

My script esta de esta forma, entonces tendría que en mi FROM hacer esa adicion de Match?

voy a intentarlo de esa forma

[luiferva]

Hola Fdoflogtz1

correcto quedaria algo como

where not Match([Categoria 1],'Servicio','Administrativo');

[sidhiq91 · Accepted solution]

@Luisanabria  We can resolve this issue in couple of ways:

1. If your table has Some Measure like some of Sales. Then we can use the below Set Analysis Expression.

Sum({<[Category Name]-={'Service','Administrative'}>}LineSalesAmount)

which will remove Service and Administrative from the Category Column.

2. If your table does not have any Measures and if it has only Dimension. Then you can use the below expression.

=Aggr(Only({<[Category Name]-={'Service','Administrative'}>}[Category Name]),[Category Name])

This should resolve your issue, if it does please like and accept it as a solution.