Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Truncated

BautistaC888
8 - Asteroid

I used this multi-row formula:

BautistaCaparelli_1-1612441363475.png

But didn't fill all the rows:

BautistaCaparelli_2-1612441484176.png

And this message appear:

BautistaCaparelli_0-1612441157653.png

I will appreciate your help.

4 REPLIES 4
mbarone
16 - Nebula
16 - Nebula

Your string size is too small.  Change to VString and make it larger.

2021-02-04 07_36_15-Window.png

Qiu
21 - Polaris
21 - Polaris

@BautistaC888 

Try as attached.

BautistaCaparelli_1-1612441363475.png

BautistaC888
8 - Asteroid

Thank you.
I'm trying to use a multi-row formula to replicate a value in empty rows.

BautistaCaparelli_2-1612443276562.png

 

BautistaCaparelli_0-1612443032254.png

But this happens:

BautistaCaparelli_1-1612443191075.png

I need to know the mistake on the expression. Thank you.

afv2688
16 - Nebula
16 - Nebula

Hello @BautistaC888 ,

 

I think I see the error. based on what I think you want to achieve the formula should look like this:

 

 

 

IF !IsEmpty([Minimo de DF]) THEN [Minimo de DF] ELSE [Row-1:Tipo de DF] ENDIF

 

 

 

This will fill up your column "Tipo de DF" with the data coming from "Minimo de DF" but if the column "Minimo de DF" is empty will take the last valid "Tipo de DF"

 

Regards

Labels