Create a column using unique column name value

[Riya1 (Riya)]

Hi Developers,

How to fetch the unique value from one of the excel column and create a headers in different excel sheet using those unique value.

Thanks,
Riya

[Raj_esh (RM)]

How to add headers in the data table - #5 by ppr Check this out pls …
Thank you

[Krishna_Raj]

@Riya1

Add column with Name and Value in each row

@Slavich Use “AddDataColumn” activity - this will create a new column. Then add values to it by using assign activity.

check out this reference

[SorenB (Søren Schytz Birk)]

Hello Riya

You can read and loop the rows of the first Excel file, and then check to see if the values in the column with unique names exist in the second Excel file column names.
If not, then you can Add Data Column with the value.

Example file: Column Headers.xaml (9.2 KB)

Regards
Soren

[lrtetala (Lakshman Reddy)]

Hi @Riya1

Try this

Uniquevalues = DT.AsEnumerable().Select(Function(row) row("YourColumnName").ToString).Distinct().ToList()

Regards,

[Riya1 (Riya)]

Hi @lrtetala ,

Can you pls tell the data type of uniquevalues variable?
Also what is the type argument of for each loop? As i am getting below error:

I have used C# language.

Thanks,
Riya

[Riya1 (Riya)]

Hi @SorenB ,

Given syntax is not working…As i am using C# language.Can u pls share the code in C#.

Thanks,
Riya

[lrtetala (Lakshman Reddy)]

@Riya1

Use below query

Uniquevalues = DT.AsEnumerable().Select(row => row["YourColumnName"].ToString()).Distinct().ToList();

Regards,