Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using formulas for presenting current selections in one row.
Nevertheless, I get 3 appearance of one field in current selections.
Here are my formulas :
fieldName
= if (index(vCurrentSelections,only({1}$Field) & ':')>0,
textbetween(
concat(TOTAL DISTINCT _OldName & ':' & _NewName,'|',_OldName ) & '|'
,only({1}$Field) & ':', '|')
)
Selection =TextBetween( vCurrentSelections & '|', only({1}$Field) & ':', '|')
Dimension-$Field -hidden.
Can you please assist - what is wrong? Why i appears three times?
It's not quite clear for me what you are trying to do but I assume you want to replace the origin fieldnames with more user-friendly names. If so I suggest to rename the fields already within the script. Applied with a mapping it could be the last work-step in your script and it doesn't need mich efforts whereby within the UI you may need some adjustments.
- Marcus
Hi Marcus,
Please see attached model.
I'm using the Current Selection Alternatives.
As you can see there duplication on fields on one example or different aperients for the same selected field on other.