Replacing one column values of a collection to an other collection

geeda

New Member
#1
Hello Everyone,
I have a collection with columns names as Fund ID, Fund Name, Date and Fund Full Name.
The values in them are (for example) 1811, FTSEDev ETF, 11/6/2018, VAG Canadian Long-term bond.
1904, Canad corp, 11/7/2018, VAG Canadian FTSE development.
1765, U.S TotMKl, 11/2/2018, VAG S&P 500 Index.

I want to get rid of that "VAG" in the Fund Full Name Column. I tried using Replace([Data.Fund Full Name], "VAG", "") in the loop of collection but it is removing VAG for the first row and not to all rows. please help me.
 

VJR

Well-Known Member
Staff member
#4
Hi geeda,

There is truly no reason for that to happen if the parameters are given right.
Can you double check the Loop, the Collection Name and the Calc stage parameters that has the Replace function.

Also check the Store Result In parameter of the Calc stage correctly.
If the issue persists can you share some screenshots.
 

geeda

New Member
#7
Hi geeda,

There is truly no reason for that to happen if the parameters are given right.
Can you double check the Loop, the Collection Name and the Calc stage parameters that has the Replace function.

Also check the Store Result In parameter of the Calc stage correctly.
If the issue persists can you share some screenshots.
not sure why! but this site is not allowing me to attach the screenshots.
 
Top