Forum Discussion
Creating unique template work
Hi All
I am in process of creating multiple template for comparing two set of data. I need to repeat few steps again and again in all template.
Is there any way I can create a dummy template which can work on every automation, I can add the operation on excel and power query read those and perform including column names.
Hi divumj
Have a look at creating custom Power Query functions and see if that is something suitable for your use-case.
https://learn.microsoft.com/en-us/power-query/custom-function
Yes, you can use custome function .
for examle
(x,y)=> List.Difference(x,y)
3 Replies
- dk_dkSuper User
Hi divumj
Have a look at creating custom Power Query functions and see if that is something suitable for your use-case.
https://learn.microsoft.com/en-us/power-query/custom-function
- Omid_MotamediseSuper User
Yes, you can use custome function .
for examle
(x,y)=> List.Difference(x,y)
- divumjHelper I
Let me go through and check but it seems workable for me