Generating row based on specific cell characters

[Gsiva3]

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.

[atcodedog05]

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:

Workflow:

Hope this helps 🙂

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

[Gsiva3]

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]

Hi @Gsiva3 

Is it something like this.

Hope this helps 🙂

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

[Gsiva3]

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]

Hi @Gsiva3 

check in formula tool have you set it as Int.

[Gsiva3]

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

[atcodedog05]

Hi @Gsiva3 

Please change formula like below

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

[Gsiva3]

hi @atcodedog05 

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

[atcodedog05 · Accepted solution]

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