You’re offline. This is a read only version of the page.
113
Hi Guys, I have 4 different collections I would like to append into one. The 4 collections are from a different sharepoint lists and they have different field name (although the content can be similar, meaning data type). What formula would I use to be able to append the fields so that I can specify which fields (columns) should fall under a single renamed column in the output collection?
So as an example, collection1 has field called Status and UpdateComments, collection 2 has StatusStage and Comments, collection 3 has ReviewStatus and UpdateRemarks and collection 4 has Stage and StatusUpdate. What would be the formula I would use to create the output collection and append these field so that I have in the output collection Status and Comments only?
I will extend this to other fields within the 4 collections, but I wanted to get an idea of what the formula would be to create this output collection?
Share
Report
All responses (
Answers (
