Excel Automation--help

Help Studio
, , , , , , ,
1

Hi can anyone help into this Please
Here i have two columns name and id , Here i want if first index of id is Sweety1 then it continue till ‘Z’ like Sweety1_a, Sweety1_b till Sweety1_z, And after its counter will increment to 2 and the value will be Sweety2_a,Sweety2_b till Sweet2_z and if more entries of names then it continue to Sweety3,Sweety3_a,Sweety4,Sweety4_a…Sweety4_Z.
Please Help. I have to work with large set of data.

image
image727×929 32.2 KB

1 Like
2

Hi,Please help,i am trying this but this is not working
CharInc.xaml (9.8 KB)

Please do help.

1 Like
3

Hi @Anjali_Rani

Please find the attached xaml file for your reference. Try this and let me know whether it meet’s you expectations.

Cell_Hydrate.xaml (12.6 KB)

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

4

@Anjali_Rani I am trying this also. But it’s same error is anybody have solution of this error.

5

Thank you, But here i dont know How many times the Name is Present,According to that i have to increment the counter. if Sweety is present 30 times then it should stop on sweety2_C. Please help and it present 3 times then it should be like abc1,abc1_a,abc1_b and stop.According to Name its id should increase.

6

@Anjali_Rani
lets assume following:

input:
grafik
a datatable with 2 cols: Name, ID and 3*27 Sweety

Flow:

grafik
grafik693×344 58.4 KB

LINQ

(From d In dtData.AsEnumerable
Group d By k=d(0).toString.Trim Into grp=Group
Let segcnt = CInt(Math.Ceiling(grp.Count / 27))
From i In Enumerable.Range(0,segcnt)
Let seg = grp.Skip(i*27).Take(27).toList
From t In seg.Select(Function (r,idx) Tuple.Create(idx,r))
Let token = (k & i + 1 & "_" & chr(96 + t.Item1)).Replace("_" & chr(96),"")
Let ra = New Object(){k, token}
Select dtResult.Rows.Add(ra)).CopyToDataTable

Result:

grafik
grafik334×595 29.4 KB

Find starter help here:
GroupBy_1Col_GMCounter_AZSegment.xaml (7.2 KB)

2 Likes
7

Hi @Anjali_Rani

I have made the changes and attached the updated xaml file for your reference.

Cell_Hydrate.xaml (13.8 KB)

And I’m not cleared about below line. Can you please elaborate it.

Thanks.

8

Sorry, i mean, If in “Name” column if sweety is Present 3times only then its id should be Sweety1, Sweety1_a, sweety1_b and stop.
And if in Name Sweety is present 30 times then its sd should increase like Sweety1,Sweety1_a,…sweety1_z, sweety2,Sweety2_a, Sweety2_b and stop.

9

Thank you, But i don’t know in our excel file how many time the Name Sweety will appear, according to that i have to increment its id. Please help.

10

Hi, Please Check

image
image525×707 27.6 KB

Cell_Hydrate (1).xaml (14.7 KB)

11

Hi @Anjali_Rani

Did you try this? Is this meet’s your expectation.

Thanks.

12

code is doing this dynamicly, also if other names will appear.

Had you test and received a different output?

1 Like
13

I tried this and the Output is what I posted,in name their is varsa and kishu still the id got incremented

14

Hi @Anjali_Rani

Okay, If the name is different from sweety in ‘Name’ column then the bot should not write in that row. Correct me if I’m wrong.

Thanks.

15

Yes,you are right now.

16

Hi again @Anjali_Rani

Please find the attached xaml file for your reference.

Cell_Hydrate.xaml (16.7 KB)

Output screen shot:
image

Hope it’s meet your expectation. Thanks.

1 Like
17

Thanks for this hospitality. :slightly_smiling_face:

18

Thank you so much.

1 Like
19

Thank you. This is working.

20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.