LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Filling out a range with rows

    Employee
    Posted 03-09-2015 08:09

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: zebax

    Hi, new to the forum, and in need of some help with a problem I have.

    The following is an example of the data I have:
    AAA.JPG

    This is presented as one row in excel. What I would need to do, is to create a separate row for all instances of the "Certificate number" column. In this example there are 1296 items, where each has a Certificate Number ranging from ...444248 to ...445543.

    The rest of the row is equal within all Certificate Number Groups, but there are several groups, each with between 1000-100.000 unique certificates.

    I would need to give each group of certificates an unique identifier, create the individual rows, and then based on the unique identifier copy all the cells from Domain to Support Schemes to those rows.

    If someone could help with this it would be greatly appreciated, I'm sweating like there's no tomorrow over this.

    Sorry in advance if this was the wrong sub forum, or if the question is asked the wrong way!


  • 2.  RE: Filling out a range with rows

    Employee
    Posted 03-09-2015 12:19

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    Can you provide 10 or so rows of actual data?


  • 3.  RE: Filling out a range with rows

    Employee
    Posted 03-09-2015 13:29

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    I'm not sure I follow everything, but I think the gist of your problem is that you want to generate multiple records based on the Certificate Number range. See attached.

    Note that the certificate number is limited to the range of a long integer, so 2^63-1.
    Attachments:
    generateRecords.brg


  • 4.  RE: Filling out a range with rows

    Employee
    Posted 03-09-2015 14:27

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: zebax

    Originally posted by: ryeh
					

    I'm not sure I follow everything, but I think the gist of your problem is that you want to generate multiple records based on the Certificate Number range.  See attached.

    
Note that the certificate number is limited to the range of a long integer, so 2^63-1.
    I want to create unique rows for all certificate-numbers present in the range.