Collection

[janejeba]

How to transpose the Collection A into below format. Can some one help me with simple solutions. @Sukesh Kumaru @sivagelli

View attachment A.jpg

 

[pamisetty.balakrishna]

Use Collection manipulation utility-- transpose collection

 

[Sachin_Kharmale]

Hi @janejeba ,

For Transpose the collection as per your requirement design flow and code stage in object studio as bellow,

1. Main Flow in Object Studio.
View attachment 1579149569985.png
2. your Input Collection With Values.
View attachment 1579149603819.png
3. Code Stage Input.
View attachment 1579149626587.png
4. Code Stage Output.
View attachment 1579149644123.png
5. Code Stage Code.
View attachment 1579149672907.png
6. Output Collection after execution of code.
View attachment 1579149705721.png

            DataTable outputTable = new DataTable("OutputTable");
            List<int> lst = new List<int>();
            foreach (DataRow row in InputTable.Rows) {
                outputTable.Columns.Add(new DataColumn(""+row["Name"], Type.GetType("System.String")));
                lst.Add(Convert.ToInt32(row["Age"]));
            }
            DataRow newRow = outputTable.NewRow();
            for(int i=0; i< lst.Count;i++) {
                newRow[outputTable.Columns[i]] = lst[i];
            }
            outputTable.Rows.Add(newRow);
            ResultCollection=outputTable;

I hope it will help you,.,!

 

[janejeba]

@Sachin_Kharmale Thanks for the response.

I’m getting the error message stating “Object reference not set to an instance of an object”

 

[Sachin_Kharmale]

@Sachin_Kharmale Thanks for the response.

I’m getting the error message stating “Object reference not set to an instance of an object”

Send your code stage window screen shot with input and output .

 

[janejeba]

When in click the Check code button it shows zero errors. But when I tried to execute I’m getting “Object Reference Error”

I don’t have access to share screen shot. I’m sure that no mismatches in i/p and o/p names.

 

[janejeba]

Hi Sachin,

I have shared the screen shots here..

 

[Sachin_Kharmale]

Hi Share your code stage code screen shot

 

[janejeba]

Hi Sachin,

please find the attached code stage screen shot

 

[janejeba]

Is it mandatory to add any DLL & name spaces for writing code in c#. This is the first time I'm using code stage with c#

 

[Janadeva]

Yes DLL & name spaces are mandatory

 

[janejeba]

Could you please provide me the list of name spaces & DLL files I have to add

 

[Sachin_Kharmale]

Hi @janejeba ,

Add following namespaces in init page of Object.
View attachment 1579599165231.png
I hope it will help you.!

 

[janejeba]

Hi Sachin,

Finally It worked . Thanks for your support. I have added the DLL & namespaces listed in the attachment you shared.