Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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.
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.
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
Hola Fdoflogtz1
correcto quedaria algo como
where not Match([Categoria 1],'Servicio','Administrativo');
@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.