Hi,
I was trying to understand how does this work:
So, I created the
1. Sample File first
2. then the Sample File Parameter1
3. Transform Sample File from Query1
4. the function Transform File from Query1
Everything seems to llok fine except that the function Transform File from Query1 is not receiving the transformation that I do from Sample File Query1.
I do have a purpose why I'm trying to learn this but that would be a different story. Can anyone help me with the above please?
Note:
#3 and #4 has the same exact codes except ofcourse for #4 where you have the parameter above and the step it will retun to like:
Code in #3
let
Source = Excel.Workbook(#"Sample File Parameter1", null, true),
Count_Sheet = Source{[Item="Counts",Kind="Sheet"]}[Data],
#"Filtered Rows" = Table.SelectRows(Count_Sheet, each ([Column1] <> null))
in
#"Filtered Rows"
Code in #4
let
Source = (#"Sample File Parameter1") => let
Source = Excel.Workbook(#"Sample File Parameter1", null, true),
Count_Sheet = Source{[Item="Counts",Kind="Sheet"]}[Data],
#"Filtered Rows" = Table.SelectRows(Count_Sheet, each ([Column1] <> null))
in
#"Filtered Rows"
in
Source
but if I add more steps to #3, it does not reflect in #4. And even if I manually copy all the step applied in #3 to #4 it does not reflect to the main query.
My version doesn't even have the Edit Function warning when I try to open it in the Advanced Editor.
