Forum Discussion

MT_1909

Copper Contributor

Oct 30, 2023

Data transformation using Power Query?

Hi Everyone, I have a worksheet with 50k+ rows and would like to create a lineage using power query but I can't seem to get it right. Can someone please help? Thank you so much in advance! ...

BI & Data Analysis

excel

Formulas and Functions

power bi

peiyezhu

Bronze Contributor

Oct 31, 2023

MT_1909

how about sql?

create temp table aa as 
select fillna(iif(rowid=1 or length(f01)<2,rowid,'')) grp,* from 基础堆叠转二维;
select * from aa;
select colIndex[0:3],group_concat(f04||'</td><td>'||f05||'</td><td>'||f06,'</td><td>') detail from aa where length(f01)>2 group by grp;

MT_1909

Copper Contributor

Oct 31, 2023

Hi peiyezhu,

I don't think I can use sql in power query or am I wrong?

Also no need for the blank rows.

Please let me know if you know of a solution using the Power Query UI?

Thank you!

peiyezhu
Bronze Contributor
Oct 31, 2023
MT_1909
I don't think I can use sql in power query or am I wrong?
You are right.
You can not use sql in power query.
It is online sql.

https://b23.tv/wEH3Fev

Please let me know if you know of a solution using the Power Query UI?
Sorry,I do not konw any solution using the Power Query.