Forum Discussion

athomp15's avatar
athomp15
Helper I
6 years ago
Solved

Append to string based on number (loop)

Hi,    Any help would be appreciated.  I have a source table that shows allocated resources on a project. I would like to add a new column which appends to the "Resource Allocated" column ";Anothe...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    6 years ago

    You can do this with a custom column that repeats ";Another" according to the missing amount:

     

    [Resources Allocated] & Text.Repeat(";Another", [Resources Missing])

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi athomp15 

If AlexisOlson slove your problem, could you kindly accept this as a solution?

If not, please let me know how to get target table from your original table?

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.