Find, If its not a last record

Hi kulkarni21vinee 

As per my understanding, to avoid appending an extra pipe symbol | at the end, you can use Text.Combine directly with a delimiter without manually adding | . Modify your code as follows:

#"Extracted Values" = Table.TransformColumns(
    #"Filtered Rows",
    { "WorkLoadDetails", each Text.Combine(List.Transform(_, each Record.Field(_, "MaintenanceDescription")), " | ") }
)

The Text.Combine function allows you to specify a delimiter ( " | "  ), and it automatically ensures no trailing delimiter is added. No need to check for the last record manually. 

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS