Can someone advise one how to get a cleaner data export.
Currently i have a collection that is being exported out to CSV file however i get alot of brackets.
Below is the syntax to export collection to csv.
ClearCollect(ColConsumAll,AddColumns(ColConsumMain,"OrderNo",Filter(ColConsumDetails,MasterID=ID).OrderNo,"NCRNo",Filter(ColConsumDetails,MasterID=ID).NCRNo,"Description",Filter(ColConsumDetails,MasterID=ID).Description,"OpsNo",Filter(ColConsumDetails,MasterID=ID).OpsNo,"WorkCentre",Filter(ColConsumDetails,MasterID=ID).WorkCentre,"Batch",Filter(ColConsumDetails,MasterID=ID).Batch,"HeatNo",Filter(ColConsumDetails,MasterID=ID).HeatNo,"Mass",Filter(ColConsumDetails,MasterID=ID).Mass,"Qty",Filter(ColConsumDetails,MasterID=ID).Qty,"Dia",Filter(ColConsumDetails,MasterID=ID).Dia,"Brand",Filter(ColConsumDetails,MasterID=ID).Brand,"PartNo",Filter(ColConsumDetails,MasterID=ID).PartNo,"Balance",Filter(ColConsumDetails,MasterID=ID).Balance));Set(ConsumableSumVar,Exporttoexcel.Run(JSON(ColConsumAll,JSONFormat.IncludeBinaryData)));Download(ConsumableSumVar.filelink)
