0

The task is simple to understand, I have a table like this:

table 1

And I would like to edit the column "L1_latitud" to collapse (or remove) all the blank cells:

table2

It looks like a simple task but I can't find out a way to deal with it.

pnuts
  • 58,317
  • 11
  • 87
  • 139
Jesus
  • 655
  • 1
  • 7
  • 21

2 Answers2

1

Not sure this is a programming question, but if what you show is a single Refine record (you can check by switching from Row mode to Record mode for viewing), you should be able to use "Join multi-valued" cells to collapse all the values into a single string with separators. From there the split(), filter(), join() methods would allow you to filter out the empty values and put the string back together. Finally, "Split multi-valued cells" would split them out into separate cells again.

I sense that you've already done some processing here, so there might be an easier way to do this if you started a step or two earlier in the process.

Tom Morris
  • 10,490
  • 32
  • 53
0

Create "Facet" -> "Customized facets" -> "Facet by null"

screenshot

then simply exclude True choice in facet

Jeremy Caney
  • 7,102
  • 69
  • 48
  • 77
wro
  • 3
  • 2