pivot hour to minutes workflow

Petar Novakovic 41 Reputation points
2023-01-21T17:49:58.8666667+00:00

I need to pivot each row in a table as follows.

From:
sc1j

To:
sc2j

Each hour of the day represented from h1 to h24 listing total minutes worked minus break.

What would be the best workflow for this process?

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,415 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,246 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MayankBargali-MSFT 70,841 Reputation points
    2023-01-30T04:58:01.12+00:00

    @Petar Novakovic Thanks for reaching out. You can leverage logic app workflow for the automation as per your business needs. Please review the limitations of the excel connector and verify if it fits as per your business needs. Once you have verified then you can leverage the List rows present in table to get the rows of your excel and then leverage the tokenized value as the column name to get the actual cell value. Now you can leverage the date and time function to get the hour part of your value and as per your business logic calculate the value using different function expression, control statement such as condition, loops etc in your workflow. To add a row, you can leverage Add a row into table action

    Feel free to get back to me if you need any assistance.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.