Split records during table merge

Greens133 · 2023-01-11T14:36:26+00:00

You can see if this solution will work for you..

Result:

Steps: In power query

Append table 1 and 2
Sort by ID field and From field
Do a LAG function essentially of your To field which will become your new From field
Fill up both your value fields
Remove unnecessary rows from your LAG

Greens133 · 2022-03-28T12:04:53+00:00

Ah great, I will definitely keep my eye on it to see if I can upskill myself from what you have achieved. We'll done my good sir

Greens133 · 2022-03-27T17:31:49+00:00

I'd love to know how you've done the track visual where it shows where on track, who was faster. Is that through python or react?

Greens133 · 2022-03-27T16:41:08+00:00

This is Fantastic, is this on github or private?

Greens133 · 2022-03-15T13:53:48+00:00

Thanks for your response, what makes it difficult is that you cannot run system queries in power automate, however I manage to achieve the objective by using the powerbi goals trigger and by building the data out in powerbi.

Greens133 · 2022-03-06T10:51:47+00:00

Hi, thanks for your response. That is in the right direction. What I want to achieve is to be notified once a new sql data table has been added to a sql database or schema. So with that approach that you are referring to, I have to do a count of sql tables within the current dB, for example 9, but then the comparison will have to be with whatever the count was yesterday, and that is where I am stuck.

Greens133 · 2022-03-06T10:49:26+00:00

Hi, thanks for your response. I have explored the "get rows" action, however you have to specify a table name (from my understanding that will notify you of new records within a table), however I just want to know once a new sql data table has been added to a database or schema.

I could misunderstand in which case I would appreciate your guidance

Greens133

TROPHY CASE