Start Free Trial

Alteryx Designer Desktop Discussions

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

Generating row based on specific cell characters

Gsiva3
8 - Asteroid

Hi all,

 

I have a input as attached below. I have four columns named as A,B,C & Length of B. 

So now what I want is, if the value in Length of B column is = 17, I need two separate outputs as mentioned below

(a)then I need to generate a new row

(b) Then I need to generate a duplicate row with data from the row that contains Length of B=17

 

Can anyone please suggest me a way to do this so.

13 REPLIES 13
atcodedog05
22 - Nova
22 - Nova

Hi @Gsiva3 

 

Here is a workflow for the task.

You can set row count as 2 for length of B = 17 or else 1 and generate rows accordingly.

Output:

atcodedog05_0-1606129108819.png

Workflow:

atcodedog05_1-1606129123561.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Gsiva3
8 - Asteroid

Thanks for the reply.

 

My one more requirement is I need to add empty row based on the above mentioned

Can you help me with it

atcodedog05
22 - Nova
22 - Nova

Hi @Gsiva3 

 

Is it something like this.

atcodedog05_0-1606130256078.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Gsiva3
8 - Asteroid

Hi @atcodedog05 

 

I am getting parse error in Generate Row tool. Please provide me a solution for this. I have attached the error screenshot

atcodedog05
22 - Nova
22 - Nova

Hi @Gsiva3 

 

check in formula tool have you set it as Int.

atcodedog05_0-1606132666404.png

 

Gsiva3
8 - Asteroid

If I am keeping like what you said, again a parse error is coming for which I have attached the screenshot

atcodedog05
22 - Nova
22 - Nova

Hi @Gsiva3 

 

Please change formula like below

IF [Length of MFAL]="21" THEN 3 ELSE 1 ENDIF
Gsiva3
8 - Asteroid

hi @atcodedog05 

 I have changed the formula, but still same error occurs.

atcodedog05
22 - Nova
22 - Nova

Hi @Gsiva3 

 

Dont use quotes use 3 not "3"

 

You can copying the below formula and using it. I have changed the column name.

IF [Length of MFAL]="21" THEN 3 ELSE 1 ENDIF

 

Labels
Top Solution Authors