Expand values operation not working properly

February 23, 2012 2:48PM

I have a column with the following structure:
AAAAA|BBBBB|CCCCC|DDDDD|

I am trying to use the expand values but I am running into a problem.
Some of the fields separated by | just contain spaces and when that is the case, visokio just ignores that the field is there.

So, for example AAAAA|BBBBB|CCCCC|DDDDD| is split in five fields containing, AAAAA, BBBBB, CCCCC, DDDDD and an empty field.

But if I have a record like (I add " for clarity): " |XXXXX| |YYYYY|", then the first field will contain XXXXX (instead of being empty), the second YYYYY (instead of XXXXX), the third will be empty (correct but for the wrong reason), the fourth will be empty (instead of YYYYY) and the last one will be empty (always the case).

I unclick "Auto-convert to empty" in the excel import.

Is there a way visokio could put the right value in the right field or is it a bug?

Cheers,
Pascal.

chris · February 24, 2012 4:52AM

Hi Pascal,

We have now added an option "Expand empty values" into the Expand values configuration panel. When selected, empty values will be included and expanded. When unselected they will be ignored.

I have attached a screenshot of a DataManager workflow based on your example above. In the example I am expanding "|XXX||YYY|". With Expand empty values selected this creates five separate columns "[Empty],XXX,[Empty],YYYY,[Empty]".

This functionality will be available in tonight's Omniscope 2.7 release.

February 24, 2012 12:39PM

Excellent, thank you.

Welcome!

Categories

Ideas Parade

Tagged