Adding the time transaction details

Use these steps to add the time transaction details.

  1. Create a nested loop controlling the repetitive Transaction element in the output document.

    The loop is controlled by a Restructure function.

  2. Select transaction data and input loop.

    Follow these element movements:

    Element Movement
    Date
    1. Drag and drop from the input document to the second inner Restructure function
    2. Link the corresponding output parameter to the Date element in the output document
    Hours
    1. Drag and drop from the input document to the second inner Restructure function
    2. Link the corresponding output parameter to the Hours element in the output document
    Time

    Drag and drop the Time repetitive element from the input document to the second (inner) Restructure function’s header.

    This element gets all time transactions per project, as handled by the outer Restructure function.
    Note: We do not need to link from the Employee repetitive element again. It is already linked to the first (outer) Restructure function. So the restructure logic already knows that we loop on Employee in the input document, but it does not do any harm to link the Employee element once again.
    Rest_ex3c_8003d8f6_8004b3a6.png
  3. Sort the data.

    Follow these property settings:

    Property Setting
    Sorting Sequence

    1 for Date

    This setting is used to sort the transactions per date and per project.