cell splitter by position + flow variable

[sanderlenselink]

HI all,

I’m confused why an ostensible simple flow doesn’t work . . .

I try to split a cell by using Flow Variable

What could be wrong?

NB: I must use Flow Variable because the actual dataset has several different split points

split_by_position_20230511.knwf (8.7 KB)

[ipazin]

Hello @sanderlenselink,

flow variable needs to be type String.

Br,
Ivan

[sanderlenselink]

@ipazin . . .

hmmmmm . . . strange . . . after your feedback I changed the type but still the same error

Or do you mean something else?

[ipazin]

Hello @sanderlenselink,

same warning is given but execution should work.

Br,
Ivan

[HansS]

Hi @sanderlenselink

Works on my machine.

[sanderlenselink]

@ipazin

the node requires a value in the split point box. It cannot be empty. And if I fill in a value the split-process the process goes wrong (of course)

[sanderlenselink]

@HansS

looks the same as your screenshot . . .

[ipazin]

Hello @sanderlenselink,

yea actually the flow variable type is irrelevant. Tnx @HansS.

But you are right - split index field can not be empty but result are not wrong. Maybe you want to split each row based on value in that row? For that you would need loop I believe.

Br,
Ivan

[HansS]

My flowvariable split_postition is of type Integer; yours is of type String…?

[sanderlenselink]

@HansS . . . I changed it to String due to @ipazin earlier remark

[sanderlenselink]

@ipazin

but strange . . . @HansS indicated it works on his machine

So an incompatabilty of my machine?

[ipazin]

Hello @sanderlenselink,

check workflow attached. At each row column is split on index 2. This is how it’s configured and it should work.
split_by_position_20230511_ipazin.knwf (14.7 KB)

Br,
Ivan

[denisfi]

HI guys,

Some tips here…

1- When you set a table row to variable, it will set only one info, not row by row… If you need to pass row by row, use the chunk loop node and set 1 row per loop. Inside the loop, you pass the point as your example to match the case.

2- the cell splitter need to have a value at the window, even you will use a flow variable to set it… so just put anything there to fill the blank.

The result

split_by_position_20230511-denis.knwf (26.6 KB)

Thanks,

Denis