Step1 - Read column from Read column activity.
Step 2 - Iterate each column value one by one in for each activity.
Step 3: Write your if condition in body of loop and start update your value in excel from write cell activity.
Thanks @ermanoj3101 , It’s OK for Step 1 & 2 , but for step 3 nothing is showing that the Write Cell Activity will write horizontally ( row) and not Vertically ( Column) . Please explain more for this step.
But as you have mentioned, you have some if condition through which you have to decide on which column that value should update.
So you can write those value accordingly by giving address as “A1” or B1 or C1 in those if blocks for horizontally.
For vertically it should be mentioned as A+icounter
Thanks @Palaniyappan for Asking, hope same for you , long time ago we didn’t hear from you
Regarding your answer, I’m not sure if you understand my exact query, I want to have at the Output Data written in row instead of Column for each array as follows :
Anyway @ppr , I will check this Topic on Academy as you said … at least my issue is fixed and I will be able to continue my project. Thanks again for you and all the Team that collaborate on that @Krishna_547@ermanoj3101 and @Palaniyappan … I’m really appreciate about the JOB you’re doing in UiPath Community … Keep Doing
@ppr, Last Query before closing this Topic: I see that for grouping the item you’re using 2 Strings :
(From d In dtData.AsEnumerable
Group d By k=d(0).toString.Substring(0,2) Into grp=Group
Let gl = grp.Select(Function (x) x(0)).toList
Select Tuple.Create(k,gl)).ToDictionary(Function (t) t.Item1, Function (t) t.Item2)
Can you replace this by what is declared whatever it’s length ( Whatever written in Column A in Sheet2 in My Example?
Lets assume first col (index 0) holds the grouping info, second col holds the values
give a try on
(From s In dtData.AsEnumerable.Select(Function (x) x(0).toString).Distinct()
Where Not (isNothing(s) OrElse String.IsNullOrEmpty(s))
Let grp = dtData.AsEnumerable.Where(Function (f) f(1).toString.StartsWith(s))
Let grv = grp.Select(Function (v) v(1)).toList
Select Tuple.Create(s, grv)).ToDictionary(Function (t) t.Item1, Function (t) t.Item2)
feel free to replace the col index with the col name