Excel Multi row labels are getting cut off

I am importing an excel file where the column labels are displayed in two rows (they are a single cell, but formatted to display in two) for example: 'Risk Status' is displayed as:

Risk

Status

on import in Alteryx i only see 'Risk', but if i select the column label, i can see it is named 'Risk Status' in the 'Field Information' window. However in the Multi-Row formula tool I only see 'Risk' in the Group By section.

Is this a bug? Any one see this before?

Input

Bug

Accepted answers

AbhilashR

Hi @Dan5, give the attached solution a try. This is how I set up my Input tool:

I use the Multi-Field formula tool to apply the same logic across multiple fields, and the final output looks like this:

I hope this helps. Let us know if this addresses your ask.

sample_v2.yxmd

All comments

AbhilashR

Hi @Dan5, I have seen this happen when the column header has a lot of white spaces in it. in this case Risk <.space.......>Status. In such cases I typically read column header as part of the data itself by unchecking First Row Contains Field Names field in the Input tool. I attempt to process these column names within Alteryx to remove the blank spaces if I don't like them.

Attached is a sample implementation of how I address such issues. Please let us know if this isn't what you are looking for.

sample.yxzp

Dan5

Thanks!,

That is a great find, and solution. It doesnt seem to work for my columns though, not sure why. Can you maybe explain the syntax a bit in the formula? Maybe i need to tweak it. What if i have many columns to correct? Would my only option be to write a formula for each column name?

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335