Multiple Text to Columns for a Single Row Creating Single Row Output

[JAB95]

Objective: I need the Entity, Segment and Geography columns broken out by the space character via Text to Columns. 

Problem: The output currently produces 3 rows for the one original row. I need the output in one clean row. 

Any help is appreciated!

[AngelosPachis · Accepted solution]

Hi @JAB95 ,

You are on the right path, but instead of having all 3 text to columns tools in a different stream, just put them in the same one.

That will prevent having 3 rows for each original row.

Hope that helps,

Angelos