Reading from excel - embedded newlines. Putting column names into one line?

[wonka1234]

Hi,

is there a way to put column names into one line?

Looks like an excel input is throwing off my entire workflow by having cells in the excel sheet have multple lines for header.

Can we work around this somehow and make columns headers 1 line?

thanks.

[Prometheus]

Do you have some dummy data we can see?

[wonka1234]

@Prometheus 

sure. So what i mean is that in the select tool the columns look fine, but the cleanse, one gets shortened.

see attached.

[Prometheus]

You can use a formula in a Dynamic Rename tool to replace the embedded newline with a space, thus giving you the full field name.