Pick first item of each row

[BRRLL99]

Hi Team,

In the available data I need to pick first child number based on first Pam

Available Data

old parent

k_type

old child

old quantity

old type

child

quantity

type

child2

quantity2

type2

child3

quantity3

type3

SD0087

Mangos

AB1197

0.1

Mangos

AB0077

0.33

Mangos

AS0055

1

Pam

SD0997

Mangos

GF0097

0.24

Mangos

TG6700

1

Pam

WE9900

0.3

Mangos

RE9988

0.66

Pam

AG1799

Mangos

JK8900

0.99

Mangos

TG6700

5

Pam

WE9900

0.55

Mangos

RE9988

2

Pam

SD3244

Mangos

TG6700

0.44

Pam

FG9090

Mangos

LG0011

0.88

Pam

JK0099

1

Mangos

QW9988

2

Pam

LL0099

Mangos

TY0022

1

Pam

XC0099

1

Pam

DD0066

Mangos

GF0097

Mangos

DF0123

Pam

Expected Output:

I'm looking for dynamic output Where I can input multiple rows and get expected output

old parent

k_type

old child

old quantity

old type

child

quantity

type

child2

quantity2

type2

child3

quantity3

type3

First Pam Child

SD0087

Mangos

AB1197

0.1

Mangos

AB0077

0.33

Mangos

AS0055

1

Pam

AS0055

SD0997

Mangos

GF0097

0.24

Mangos

TG6700

1

Pam

WE9900

0.3

Mangos

RE9988

0.66

Pam

TG6700

AG1799

Mangos

JK8900

0.99

Mangos

TG6700

5

Pam

WE9900

0.55

Mangos

RE9988

2

Pam

TG6700

SD3244

Mangos

TG6700

0.44

Pam

TG6700

FG9090

Mangos

LG0011

0.88

Pam

JK0099

1

Mangos

QW9988

2

Pam

LG0011

LL0099

Mangos

TY0022

1

Pam

XC0099

1

Pam

TY0022

DD0066

Mangos

GF0097

Mangos

DF0123

Pam

DF0123

[ShankerV]

Hi @BRRLL99 

One way of doing this.

Many thanks

Shanker V

[BRRLL99]

Please share the workflow or Screenshots

[ShankerV]

Hi @BRRLL99 

Step 1: Input

Step 2: 

Step 3: 

Many thanks

Shanker V

[ShankerV]

Hi @BRRLL99 

Step 4:

IF [Value]="Pam"
THEN [Row-2:Value]
ELSE ""
ENDIF

Step 5: 

Step 6:

Step 7:

Many thanks

Shanker V

[BRRLL99]

same update in the data 

as shown in the last row when 1st and 2nd are both mangos is it possible to show blanks?

old parent

k_type

old child

old quantity

old type

child

quantity

type

child2

quantity2

type2

child3

quantity3

type3

First Pam Child

SD0087

Mangos

AB1197

0.1

Mangos

AB0077

0.33

Mangos

AS0055

1

Pam

AS0055

SD0997

Mangos

GF0097

0.24

Mangos

TG6700

1

Pam

WE9900

0.3

Mangos

RE9988

0.66

Pam

TG6700

AG1799

Mangos

JK8900

0.99

Mangos

TG6700

5

Pam

WE9900

0.55

Mangos

RE9988

2

Pam

TG6700

SD3244

Mangos

TG6700

0.44

Pam

TG6700

FG9090

Mangos

LG0011

0.88

Pam

JK0099

1

Mangos

QW9988

2

Pam

LG0011

LL0099

Mangos

TY0022

1

Pam

XC0099

1

Pam

TY0022

DD0066

Mangos

GF0097

4

Mangos

DF0123

Pam

DF0123

AW0099

Mangos

FG0099

6

Mangos

-

[ShankerV · Accepted solution]

Hi @BRRLL99 

Yes, its possible.

Added the below step.

Many thanks

Shanker V

[BRRLL99]

there is small update for the last row

Incase all values are mangos it should pick the last value in this case DF0123

old parent

k_type

old child

old quantity

old type

child

quantity

type

child2

quantity2

type2

child3

quantity3

type3

SD0087

Mangos

AB1197

0.1

Mangos

AB0077

0.33

Mangos

AS0055

1

Pam

SD0997

Mangos

GF0097

0.24

Mangos

TG6700

1

Pam

WE9900

0.3

Mangos

RE9988

0.66

Pam

AG1799

Mangos

JK8900

0.99

Mangos

TG6700

5

Pam

WE9900

0.55

Mangos

RE9988

2

Pam

SD3244

Mangos

TG6700

0.44

Pam

FG9090

Mangos

LG0011

0.88

Pam

JK0099

1

Mangos

QW9988

2

Pam

LL0099

Mangos

TY0022

1

Pam

XC0099

1

Pam

DD0066

Mangos

GF0097

2

Mangos

DF0123

2

Mangos