Transform data from a table with subtasks to a new task table

Question

I have the following data structure:Id&nbsp; ProjName1&nbsp;&nbsp; Proj12&nbsp;&nbsp; Proj23&nbsp;&nbsp; Proj3&nbsp;And subtask info:id ProjId TaskName1 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task12 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task23 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task34 3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task45 3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task56 3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task67 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task7&nbsp;But I need to breakdown the Projects Table into something like:Id&nbsp; ProjName1&nbsp;&nbsp; Proj12&nbsp;&nbsp; Proj23&nbsp;&nbsp; Proj34&nbsp;&nbsp; Proj45&nbsp;&nbsp; Proj5&nbsp;And to point Task5 to Proj4 and Task6 to Proj5 maintaining the rest without changes. What type of Query Can I make? I'm completly newbie at R.&nbsp;Thanks&nbsp;&nbsp;

vanessafvg · Answer

R or Power BI?&nbsp;i suggest going through the guided learning videos&nbsp;&nbsp;https://powerbi.microsoft.com/en-us/guided-learning/&nbsp;&nbsp;

anonymous · Answer

vanessafvgThanks for the info.&nbsp;The problem in my case is the data model which I can not change. So I need to change it when importing the tables. I was assuming that when I do an Advance Query the language is R. Is this incorrect?

anonymous · Answer

I mixed the letter.. M Language, not R.

vanessafvg · Answer

After you have imported the tables you can change it the way you like, m is the language yes but for the most part you should be able to use the gui to get done what you need.&nbsp;You will probably get more responses if you try doing it and come up with specific issues, so my suggestion is to start importing and watch the videos and when you hit issues post them here.

anonymous · Answer

Thanks vanessafvg&nbsp;I already did the import and it works correctly for the native projects, the problem is that for two projects I need that breakdown an I was not able to do it.&nbsp;What I was thinking was to make some type of if statement in the import so that a task with proj ID=1 would in fact point to Proj ID = 10 so that way I could link to a created table with the new projects and not use the original ones.&nbsp;This was the visuals I buit previously would work exactly the same but poiting to the new inserted table.&nbsp;Is this possible?

Forum Discussion

Transform data from a table with subtasks to a new task table

5 Replies

Related content

Table Transformation

Table Transformation

Table Transformation

Transform columns / type

Table Transformation