Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am getting excel files from a folder in the goal to automate the transformation on each files.
The structure of each files is the same. See link: https://drive.google.com/drive/folders/1e_0xaOvVmSRsGXFk4m5Lt5rLE_ZH05qS?usp=sharing
The sheet to transform from each file would always be sheet1.
The app with the loaded excel files is also under the link. ( when I invoke the sheet1, I get an error)
However, the names of the first row (which is for the bike name) can change (instead of having BikeAAAA it could be BikeCCCCC).
I am trying to get the following:
ReferenceBike (which will always be the column b in each excel. ) | Bike | Bike Type | indexType | Value |
BikeAAAA | BikeBCB | EngineB | Index list price | 1 |
BikeAAAA | BikeDC | |||
BikeAAAA | ||||
BikeAAAA | ||||
BikeAAAA | ||||
BikeA | ||||
BikeA | ||||
BikeA | ||||
BikeA |
Can someone help me ?
Thanks
yes of course. Here is the link: https://drive.google.com/drive/folders/1e_0xaOvVmSRsGXFk4m5Lt5rLE_ZH05qS?usp=sharing
thank you
Hi @Chrisjr ,
The link you provided can not open. Can you reshare it again?
Looking forward to your reply.
Best Regards,
Henry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |