Excel qty

[poojaskyrathore]

i have a excel sheet with some 12 rows

condition 1 : i have the qty as 6 in first row and if its 6 i need to have 6 more rows same as that
and if second rows qty is 7 i need to have 7 more rows same as second row

what logic to be given ?

[ashwin.ashok ((TheCodingTheory))]

Hi @poojaskyrathore ,

We would appreciate it if you could provide us with some sample data to work with, along with a short example of the output.

Kind Regards,
Ashwin A.K

[poojaskyrathore]

base file

[poojaskyrathore]

in base sheet you can see hightened first row has 6 and in second sheet that 1st row is repeated 6 times and same for the 2nd row

[supermanPunch (Arpan)]

Hi @poojaskyrathore ,

Maybe you can Check the Below Post, It does have somewhat the similar requirement. Let us know if it doesn’t help :

Count duplicate rows of column and compare quantity from another datatable

Hi @mashy2 , Checking the Similar Topic created by you, I was able to get the Input Excel. Hence, I was able to create a Workflow which provides the Output as Required. However, needs confirmation from your end. Check the Workflow Below and Let us know if it satisfies your Requirements : DT_CompareQuantity_AddRows.xaml (10.2 KB)

[athira.somasekharan]

Hello Pooja,

Inside the for each row loop, you have to get the quantity value in a variable. Then use a for loop and use “Add Data Row”. What happens is, it will add the rows according to the quantity value inside the for loop.

Thanks!
Athira

[poojaskyrathore]

do you have any example ?

[athira.somasekharan]

Please see the below screenshots. Here first column has the quantity values :

Hope it helps!
Athira

[ashwin.ashok ((TheCodingTheory))]

Hi @poojaskyrathore ,

Here is a short sequence to that addresses your problem →

dt.AsEnumerable().SelectMany(Function(s) Enumerable.Range(0,CInt(s.Item("qty"))).Select(Function(si) s).ToArray()).CopyToDataTable()

Sequence.xaml (8.5 KB)

Kind Regards,
Ashwin A.K

[poojaskyrathore]

assign thing is integer

so variable type what should i give ?

[athira.somasekharan]

The quantity value should be stored in an integer variable.

Thanks,
Athira

[poojaskyrathore]

i have given this … row(31) has qty and variable cloumn1 is assinged as interger in datatype

[athira.somasekharan]

Hello @poojaskyrathore ,

This happened as the quantity value was empty. So what you can do is add a check to see if the value is empty or not. So the assign activity will become like this:
column1= if(row(31).tostring.Trim=“”,0,cint(row(31).tostring.Trim))

Please try like this and let me know.

Thanks!

[poojaskyrathore]

this is my input sheet and can you see case column (the last one ) … in this if you see third row has 7 case and i want the entire row to be repeated 7 items

[athira.somasekharan]

Yes, that’s what we are doing. Can you please show me your workflow so I can check it once?

Thanks,
Athira

[poojaskyrathore]

@athira.somasekharan

if(row(31).tostring.Trim=“”,0,cint(row(31).tostring.Trim)

[athira.somasekharan]

Instead of running, can you give debug and see exactly where this error is coming?

[poojaskyrathore]

assign thing is showing error

[athira.somasekharan]

Can you please provide me the input excel that you are working with?

[poojaskyrathore]

PO-CNNA080322-1 RAW PO.xlsx (19.8 KB)

last column has to be worked on