Add Data Column Error like in the following

[170290064 (Eyüp Hasan Akbaba)]

I just build a data table like in the following

And in the -For Each Activity- after the condition i want to add the column into my data table

but error occurs

[Sreelatha278 (Sree Latha Reddy)]

Hello @170290064 ,

looks like you already have the column in datatable and trying to add the same column name again

As per your logic, the data in Model Column should be Unique.

[170290064 (Eyüp Hasan Akbaba)]

But whats wrong adding the same column in the excel sheet

[Sreelatha278 (Sree Latha Reddy)]

UiPath Data table will not allow you to add columns with the same Name.

can you explain more about your requirement

[170290064 (Eyüp Hasan Akbaba)]

Date can be the same but other columns are changing.

Idk whats wrong with that

[Sreelatha278 (Sree Latha Reddy)]

the excel which you showed is good. Do you want to add a new column or a row.

Let us know what is the output you are expecting.

[170290064 (Eyüp Hasan Akbaba)]

the output that I’m expecting exactly the same that I showed you in the Excel Sheet so after the condition in the For Each activity if the date greater than the indicated date then I’m going to add new columns modem date and price. That’s it

[170290064 (Eyüp Hasan Akbaba)]

que-5.xlsx (25.2 KB)

This is the excel file. I ll get data from Otomobil-Modified Sheet. Then write it into the “ModelFiyatlatı” Sheet.

[170290064 (Eyüp Hasan Akbaba)]

Maybe i should add them in only one “Add Data Column Activity” or “Add Data Row Activity”

[Sreelatha278 (Sree Latha Reddy)]

yes, use add data row

[170290064 (Eyüp Hasan Akbaba)]

How to write these 3 columns with 1 row with Add Data Row Activity ???

[lrtetala (Lakshman Reddy)]

Hi @170290064

{CurrentRow(“Colun1”).ToString,CurrentRow(“Colun2”).ToString}

[Sreelatha278 (Sree Latha Reddy)]

Use assign activity to filter by date

dtModified.Select(“[İlan Tarihi] > ‘16.07.2023’”).CopyToDataTable

and use filter datatable to fetch the only columns you need

In this way you can achieve your solution without using foreach loop

attaching xaml file for your reference.
excel1.xaml (10.9 KB)

[lrtetala (Lakshman Reddy)]

@170290064

If you got the solution for your issue. Please mark it as solution to close the thread and others also helped.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards,

[170290064 (Eyüp Hasan Akbaba)]

Thanks for all

@Sreelatha278
@lrtetala