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

Question

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 · Answer

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.

wonka1234 · Answer

@Prometheus

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

see attached.

twolineinput.yxzp

Prometheus · Answer

Do you have some dummy data we can see?