How to use Multi-Row Formula but instead of IsNull, the test is if row has leading spaces?

Hi everyone!

I just wanted to know if I can use the Multi-row function if I am not testing if the row is null, but instead if the row has leading whitespaces.

My data has sub-headers for each region, and I want to add the sub-header on the regions to differentiate them per sub-header.

I want them to become Revenue Asia, Revenue Canada, Revenue U.S. and Net Income Asia, Net Income Canada, Net Income U.S.

As you can see on the screenshot, my condition is not that they are null, but they have leading whitespaces.

Let me know if another function is better to use in this situation than the multi-row function. Screenshots of used formulas and functions to solve this are very much appreciated. Thank you!

Custom Tools

Parse

Best Practices

Expression

Accepted answers

BS_THE_ANALYST

@maddada I would approach it like this, assuming they may not always have trailing spaces, and when they do, what if they have multiple etc. This will cater for that.

Step 1: setup problem

Step 2: extract headers (this is where you can pull out the headers based on logic)

Step 3:
Concatenate headers and subheaders:

Step 4: Filter:

Multi_row_Headers_Subheaders.yxmd

All comments

BS_THE_ANALYST

@maddada I would approach it like this, assuming they may not always have trailing spaces, and when they do, what if they have multiple etc. This will cater for that.

Step 1: setup problem

Step 2: extract headers (this is where you can pull out the headers based on logic)

Step 3:
Concatenate headers and subheaders:

Step 4: Filter:

Multi_row_Headers_Subheaders.yxmd

maddada

Woooaaah! I didn't think of doing it that way. Thank you so much for this! 🤓

BS_THE_ANALYST

@maddada that's the beautiful thing with Alteryx, there's so many ways to do things 😎.

All the best,
BS

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703