Forum Discussion

RAKESH1986's avatar
RAKESH1986
Helper II
3 years ago
Solved

List.Transform Excel table different column combine not Working.

Hi ,

 

Could you help me, why this code is not working?

 

 

 

I have seen one video, it works fine in this video but not in my code. what wrong am I doing?

 

https://www.youtube.com/watch?v=09tvia_8ykI

 

I want to combine multiple excel sheets, having a different dynamic columns. 

  • its working by this change

    = List.Transform(PreExpand[#"Transform File (2)"],each Table.ColumnNames(_))

1 Reply

  • its working by this change

    = List.Transform(PreExpand[#"Transform File (2)"],each Table.ColumnNames(_))