Forum Discussion
Dataflow/Dataset | Reading Incoming Fixed No. of column headers but Dynamic header name
Hi, Source is an excel file and filename remains same for each month. For latest month file the data is pushed to column AE in excel and old month gets shifted to subsequent column and 16th month...
lbendlin - Thank you for your response. Ofcourse we are not hardcoding it. Here are the samples - https://drive.google.com/file/d/13Lo7xQtWxkTqT49hKeW6H-MENiyFXSxm/view?usp=sharing
The file name remains XYZ-USAGE.xlsx each month but the month columns gets added and rearranged. Can we handle this kind of dynamic files but having first row as a columnname in dataflow?
Please note it should be scheduled refresh.