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 |
Solved! Go to Solution.
Please share the workflow or Screenshots
Hi @BRRLL99
Step 4:
IF [Value]="Pam"
THEN [Row-2:Value]
ELSE ""
ENDIF
Step 5:
Step 6:
Step 7:
Many thanks
Shanker V
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 | - |
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 |