How to add data to particular column?

Help
, ,
1

Hi

I have a data-table that is formed with a few basic cols that is static and newly added cols every time a new branch is created

The data table looks like this

Name Pay Center 1 Center 2 Center 3

Now I want to add data to Center 1 if the given center for an employee is Center 1

How to do this?

1 Like
2

@Palaniyappan buddy can you help me with this?

1 Like
3

I have a friend who can answer this question, I will reachout to him and get back to you as soon as possible. I hope that is okay with you?

1 Like
4

Thanks my friend

5

I hope you got the requirement clear

I am adding cols based on new centers (locations)

I want to add data data table as always but if the employee belongs to a center his pay has to go beneath that center not in net pay column

thanks in advance

cc @Palaniyappan na

6

If all you want is to add a value to a column, use an Assign activity like this:
row(0) = MyValue

7

@bcorrea please understand the requirement

I am adding cols based on new centers (locations)

I want to add data data table as always but if the employee belongs to a center his pay has to go beneath that center not in net pay column

thanks in advance

8

Sorry, but is hard to understand where is your doubt, we are not here to do your whole work, so if you can share where you could go so far, then we can help better…

9

I’m not asking you to do the whole work

I’m just asking a small fragment of it

Sorry if I have not made the requirements clear

Here it is:

There is a datatable which contains 3 cols by default (no, name, pay, location)

I have to create a new data table for each distinct location

I have to add the pay of employee to the respective location column based on his or her location

say if there is a employee x and his location is y

I have to create a table like

no name y
1 x [his pay]

10

But still you are not saying to us where is your difficulty, which parts of your flow you dont know how to handle…

11

I have created the column based on locations but I don’t know how to add data

I cant use add data row since the col name might vary each time (this is where I’m facing difficulty)

12

So i understood since the beginning and gave you the correct answer… when you are inside a for each row you can use Assign like i told you…

13

I cannot blindly use assign since I don’t know which column to add to (I have to add the net pay of the employee beneath his location)

14

Ok your condition to know where to add the values are very much yours, it will be very hard for us to help without really knowing your project specifics…

15

How to add is the question

16

I’m still unclear on this topic can someone please help?

@denis1 @Palaniyappan @Lahiru.Fernando

1 Like
17

@lakshman

18

@cybzom

Could you show me screenshot of some sample input and output. So that I can check and help you.

1 Like
19

I’m using mobile so kindly use this screenshot

Screenshot_2020-01-06-22-28-41-679_com.miui.notes
Screenshot_2020-01-06-22-28-41-679_com.miui.notes720×1440 70.8 KB

1 Like
20

@lakshman the locations will keep adding so it has to be dynamic

I have completed the part where I am able to add n no of cols for each distinct location but I am not able to update the employee data