Hi All,
I have an input file (attaching as well)INPUT_DATA.xlsx (9.2 KB)
|TAXONOMY_VALUE|FORMULA_TAXONOMY_ID|FORMULA_TAXONOMY_ID|SEPARATE_LIST|
|10|F_1|A+B|A|
|20|F_1|A+B|B|
|10|F_2|C+D-A|A|
|30|F_2|C+D-A|C|
|40|F_2|C+D-A|D|
on which i have applied groupby node on two columns
FORMULA_TAXONOMY_ID,FORMULA_TAXONOMY_ID and done aggregation ,below is the output
for groupby
|FORMULA_TAXONOMY_ID|FORMULA_TAXONOMY_VALUE|TAXONOMY_VALUE (List*)|SEPARATE_LIST (List)|
|F_1|A+B|[10.0, 20.0]|[A, B]|
|F_2|C+D-A|[10.0, 30.0, 40.0]|[A, C, D]|
After this i want to create one new column in which i am having the resolved expression for field FORMULA_TAXONOMY_VALUE
For eg:
new column value should be 10+20 for the first row and 30+40-10 for the second row.
that is TAXONOMY_VALUE (List*) contain the numeric value need to replace the value in column FORMULA_TAXONOMY_VALUE
For this i have written the logic in column expression. but it is giving the last expression only and not the complete value and can see one more issue
split function can only take one symbol as an input separator but FORMULA_TAXONOMY_VALUE can have multiple separator.
Attaching the workflow as well.Kindly Help me to achieve this.https://kni.me/w/HTx6txddvJfa27Yy