topic Append Field type-collection in Product Forum

Append Field type-collection

MateuszWojcik — Tue, 14 May 2019 15:06:00 GMT

Hi, I want to create collection with subcollections inside one of my column. First I download collection from sharepoint, than I would like to add column using action like append field(text) but instead of text type I want my column to have collection type. Please let me know if you have any suggestion

Hi mwojcik2, This can beâ€¦

BenKirimlidis — Tue, 14 May 2019 16:55:00 GMT

Hi mwojcik2, This can be done with a simple calculation. I have attached an image with anÂ example.Â I have a collection called colCustomer which is already populated with some basic info as shown but there is a field which is called colAccount which is a collection datatype that is blank.Â I have a second collection called colTempAccount which is pre populated with some info. A single calculation stage is all that is required to store colTempAccount into the collection variable colAccount inside colCustomer . Hope that helps! Kind regards, Ben

sory image didnt save firstâ€¦

BenKirimlidis — Tue, 14 May 2019 16:55:00 GMT

sory image didnt save first time

3rd times the charm.....?Â â€¦

BenKirimlidis — Tue, 14 May 2019 16:56:00 GMT

3rd times the charm.....?Â tried jpeg this time

Hi Ben, Â Thank you for yourâ€¦

MateuszWojcik — Wed, 15 May 2019 17:14:00 GMT

Hi Ben, Â Thank you for your help. Unfortunately it is not what I am looking for.Â Your idea assumes that collection "colCustomer" already has a defined column with collection type. My process download collection from SharePoint. In this collection there are column with text and number types.Â When I have it downloaded I want to add extra column with collection type. I don't want to defined all column's type in process top avoid errors when there will be changes in SharePoint table.Â Â I have solve this problem as follow. I have created additional collection with already defined 1 column with collection type. After I download SharePoint Collection I use merge action to add both collection. Â I hope to find solution of adding additional column with collection type to main collection. Â Kind regards Mateusz

This was written in C#, butâ€¦

AmiBarrett — Wed, 15 May 2019 22:12:00 GMT

This was written in C#, but it should do what you're looking for. Some of the types are internally defined and I wasn't able to get a differentiation between them. (Text/Password, DateTime/Time)

Inputs:
Collection - Collection
colName - Text
colType - Text

Outputs:
New Collection - Collection

DataColumn col = new DataColumn();
if(colType=="Number"){ 
	col.DataType = System.Type.GetType("System.Int32");
} 
else if(colType=="Text" || colType=="Password"){
	col.DataType = System.Type.GetType("System.String");
}
else if(colType=="Collection"){ 
	col.DataType = typeof(DataTable);
} 
else if(colType=="Date" || colType=="DateTime" ||colType=="Time"){
	col.DataType = System.Type.GetType("System.DateTime");
} 
else if(colType=="Flag"){
	col.DataType = System.Type.GetType("System.Boolean");
} 
else if(colType=="TimeSpan"){
	col.DataType = System.Type.GetType("System.TimeSpan");
}
else if(colType=="Image"){
	col.DataType = typeof(Bitmap);
}
else if(colType=="Binary"){
	col.DataType = System.Type.GetType("System.Byte[]");
} 

col.ColumnName = colName; Collection.Columns.Add(col);Â Â  Â  New_Collection = Collection;

Thank youÂ amibarrett. I haveâ€¦

MateuszWojcik — Wed, 22 May 2019 17:22:00 GMT

Thank youÂ amibarrett. I have solve my problem in the following way. I create a collection "coll1" where 1 column "Shp_col" has defined type of collection. Coll1 is merge with collection obtained from SharePoint list "SHPcoll". Next I loop through SHPColl and add with calculation stage "coll3" to column "Shp_col". coll3 contains relevant data for specific row in SHPcoll.