Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have a table which looks like this:
Nr. | Kontoart | From Account | To Account |
100 | Managementfee | 10110 | 10113 |
110 | Lejeindtægter | 10121 | 10124 |
120 | Øvrige indtægter | 11210 | 11212 |
and I would like it to end with this result:
Nr. | Kontoart | Account |
100 | Managementfee | 10110 |
100 | Managementfee | 10111 |
100 | Managementfee | 10112 |
100 | Managementfee | 10113 |
110 | Lejeindtægter | 10121 |
111 | Lejeindtægter | 10122 |
112 | Lejeindtægter | 10123 |
113 | Lejeindtægter | 10124 |
120 | Øvrige indtægter | 11210 |
121 | Øvrige indtægter | 11211 |
122 | Øvrige indtægter | 11212 |
any Ideas for that will be appreciated very much!
Solved! Go to Solution.
Hi @DanJohansen ,
Assuming your From/To columns are in numerical format, you can add a custom column like this:
= {[From Account]..[To Account]}
You can then expand the nested list column to new rows.
If your original columns aren't numerical, then you'll need to wrap the column references in Number.From:
= {Number.From([From Account])..Number.From([To Account])}
Pete
Proud to be a Datanaut!
Thx Pete! You are a life saver! Whereever you are, have a nice day! 😄
Hi @DanJohansen ,
Assuming your From/To columns are in numerical format, you can add a custom column like this:
= {[From Account]..[To Account]}
You can then expand the nested list column to new rows.
If your original columns aren't numerical, then you'll need to wrap the column references in Number.From:
= {Number.From([From Account])..Number.From([To Account])}
Pete
Proud to be a Datanaut!
Hi Pete! Thx for answering and yes, the two columns are numerical, but I get this error:
Hi @DanJohansen ,
Apologies, I updated my answer with the curly braces that are needed right after I posted, but you'll need to refresh your browser (F5) to see (basically, put curly braces around the whole thing).
My bad.
Pete
Proud to be a Datanaut!