Forum Discussion
Nino_Birdie
6 years agoFrequent Visitor
Remove duplicates and blanks
Im trying to make a calculated table and i cant remove the duplicates, leaving blanks between data. The query is the following: DatosExtra =
DISTINCT(SELECTCOLUMNS(EstadosPostulantes;
...
Nino_Birdie
6 years agoFrequent Visitor
amitchandak meanwhile i have created a mockup of what i expected, and also new columns Called NExito and NFracaso, the following query :
DatosExtra =
UNION(
ROW("Etapa";1;"Exito"; 1;"Fracaso";"";"NExito";"a";"NFracaso";"");
ROW("Etapa";2;"Exito";3;"Fracaso";2;"NExito";"c";"NFracaso";"b");
ROW("Etapa";3;"Exito";5;"Fracaso";4;"NExito";"e";"NFracaso";"d");
ROW("Etapa";4;"Exito";7;"Fracaso";6;"NExito";"f";"NFracaso";"g");
ROW("Etapa";5;"Exito";9;"Fracaso";8;"NExito";"i";"NFracaso";"h");
ROW("Etapa";6;"Exito";11;"Fracaso";10;"NExito";"k";"NFracaso";"j");
ROW("Etapa";7;"Exito";13;"Fracaso";12;"NExito";"m";"NFracaso";"l")
)
Returns the following (what i expected):
So, is there something i can do to replicate that? By making rows or columns?
Nino_Birdie
6 years agoFrequent Visitor
Up. I still cant figure how to do what i need 😐