Adding Data in same column again and again

Help Studio
, , , , , ,
1

Hi, can anyone help me into this, i have to process the data result should be write 5 times in same column
Like for Last name data there are 5 values and all appropriate values should be written only in 1 last name column for one first name.
image

/please help

2

Hi @Anjali_Rani

Can you show one sample input and output.
What is the source of input?

Do you want the output in this format

image

Thanks

1 Like
3

You can try using linq-group by and get the datarows, put in datable abd hence in excel

1 Like
4

yes ,This is input as an Googlesheet image
There is one condition i have , in which it will check for 5 last name and the good one is appended in Last name as, image
and then status field is marked as yes.
Like this

5

This would be a great use of dictionaries and lists. You can create dictionary(of string, list) and then loop through your data. You can then reference the lists the same way you’d reference any dictionary item. You can add the last name to each list.

For example, you’d have myDict(“James”) which contains a list “Bond, Cameron”

Then you can write that data to the spreadsheet.

1 Like
6

Thank you. If possible Please help me with xaml file.

7

Where are the last name given?

8

ok, Like image

i have 3 fields , i will first check email by , Ram@gmail.com then Ram@12.com,Ramsinha.com,RamS@gmail.com so whichever the valid email i got should go on Email column, , so here, Ram@gmail.com and RamS@gmail.com should append in email column,I will validate this email and after append in Email field

9

@Anjali_Rani

This is a new requirement. I am unable to understand.