Forum Discussion
update canceled from transform files
Hi Elodie
You can create a new function from "Transform Sample File" query and give the new function a different name from "Transform File", e.g. "newFunction". This new function will be binded to "Transform Sample File".
Then modify the step "Invoke Custom Function1" in the main query to invoke this new function instead of the old "Transform file". The outcomes are in the column "Transform File". You can check the results in the tables.
The old "Expanded xxxxxx" step may have some problem. You can remove that step and expand the table column "Transform File" manually.
Reference: Relinking Transform Sample File query with function in Power Query? - Microsoft Community Hub
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi Elodie
You can create a new function from "Transform Sample File" query and give the new function a different name from "Transform File", e.g. "newFunction". This new function will be binded to "Transform Sample File".
Then modify the step "Invoke Custom Function1" in the main query to invoke this new function instead of the old "Transform file". The outcomes are in the column "Transform File". You can check the results in the tables.
The old "Expanded xxxxxx" step may have some problem. You can remove that step and expand the table column "Transform File" manually.
Reference: Relinking Transform Sample File query with function in Power Query? - Microsoft Community Hub
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi Anonymous
Thank you so much for your reply !!!! I have just seen it !
II'm going to test your solution right away!
thanks again!
Best regards,
Elodie