hi,
i am using a!forEach to create a list of variants and wanted to return the iteration item as Array/List itself
for eg,
a!localVariables( local!testVariable: { "A", "B", "C;D" }, local!valuesAsArray: a!forEach( items: local!testVariable, expression: if( length(split(fv!item, ";")) > 1, split(fv!item, ";"), fv!item ), ), local!valuesAsArray)
Above expression is returning results as {"A", "B", "C", "D"}
Instead i wanted the results as {"A", "B", {"C", "D"}}.
Any suggestions on how to achieve this
Discussion posts and replies are publicly visible
Appian automatically flattens such lists. I do not know of a reliable way to get the result you are looking for.
If we're allowed a little leeway on what the format of the resulting data can be, it's pretty easy to handle this using a list of maps:
Hi palanir043114 ,
a!localVariables( local!testVariable: { "A", "B", "C;D" }, local!valuesAsArray: a!forEach( items: local!testVariable, expression: {split(fv!item,";")} ), local!valuesAsArray )
Let me know if this works!!
Hi palanir043114 ,You can't get the exact expected result as Appian will Flatten the list as we cannot seperately add few nested lists at the end.And this is the expected behaviour in Appian arrays.The Output Expression you get at most probable from Mike Schmitt & Vyshnavi Naripeddi expressions is {{"A"}, {"B"}, {"C", "D"}}
Hi palanir043114 , Try using the code below.