Excel rows, create list only from integer numbers of rows

[Danny_Gi]

Hi guys, i need to create some lists from an excel file.

explain:
In my excel in a column “A” there are numbers that give me the right order of my bill of materials and in “B” the relative codes.
That number, in a integer indicate the main code and in a decimal the children of the main code.

Example
1 - ASM30050069
2 - SGA30050070
2.1 - SGE30050071
2.2 - SGE30050072
3 - SGA30050073
4 - ASM30050074
5 - SGA30050075
5.1 - SLE30050076
5.2 - SGE30050077

In this example the main code 2 in Column “A” have the code in “B” SGA30050070.
I need to create a list automatically to get the main code SGA30050070 and all the children. In this case
2.1 - SGE30050071
2.2 - SGE30050072

for all of elements of my excel file.
In this case i attach an excel example to understand better what i need, but sometimes the code in my excel BOM are thousand and thousand.

Thank you
ASM31104662 SPINTORE 3500-900 V3.xls (109.5 KB)

[Danny_Gi]

Hi @prasath17 no, i want to extract the code of the main article and the code of all childrens

[prasath17 (Guru)]

@Danny_Gi

2.1 - SGE30050071
2.2 - SGE30050072

Are you trying to Concatenate Column A and B separated by - ??

[prasath17 (Guru)]

@Danny_Gi

no, i want to extract the code of the main article and the code of all childrens

Got it…Here you go…

Output:

Note: Here (1) - means 2nd column… to get the main code use (0)…

ArrStringNumeroparte = List < string >
ArrStringMainCode = List < string >

[Danny_Gi]

Not exaclty.

I want to get the B value only. But the list is from A numbers.
Again, wait i’m trying to explain better.

In column B ive the code of components, but the hierarchy is from column A.

Column A say me who is the “father” and who is the children.
If in column A there is a integer number, is a father.
If there is a decimal number, is a children. But the family is indicate from integer number!

if integer number is 2 (and relative code in column B is ASM30050070) and childrens are 2.1 and 2.2 (and relative code in columb B are SGE30050071 and SLE30050072) i want a list which contains The code of number 2 and the codes of numbers 2.1 and 2.2

[ppr (Peter)]

@Danny_Gi
we do feel that a list with 1,2,3 will not help your case
Also a list with all number will not add a value.

Looking on this from another viewpoint we do see the chance to form groups based on main and sub items.

for this we can use a group by approach:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

and if we do the grouping by logic like bring e.g. 1 and 1.1,1.2 … etc together we can segment the data for a further processing.

Here following statement will help for defining the group key:

Let us know if you want to get more help on this group by approach. Thanks