Forum Discussion

Phil_Oliveira's avatar
Phil_Oliveira
New Member
1 year ago
Solved

skip query step if condition is met

Hi masters,    is it possible to skip a whole query step (ex below: Combined_Exp_) if a condition is met. The query "Combined_Exp_" is basically loading data from a file that will be merged further...
Need Help
Tips and Tricks
  • Phil_Oliveira's avatar
    Phil_Oliveira
    1 year ago

    Thanks for the help. I found the solution I was looking for. The script should look like the following:

    let

        Source =

            if List.Single(DateList) = null then

                Excel.Workbook(File.Contents(""C:\Mydocuments\Test.csv"), null, true)

            else

                null, // Preventing further steps if Source is null

        Output =

            if Source = null then

                #table({}, {}) // Returns an empty table

            else

                let

    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", Int64.Type}, {"Code", Int64.Type}, {"Value", Int64.Type}})

               in

                    #"Changed Type"in

        Output

Phil_Oliveira's avatar
Phil_Oliveira
New Member
1 year ago

Thanks for the help. I am new with power query so I am not sure if I got it right. Should the query look something like this:

 

let
Source = Csv.Document(File.Contents("C:\Mydocuments\Test.csv"),[Delimiter=",", Columns=83, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", Int64.Type}, {"Code", Int64.Type}, {"Value", Int64.Type}}),

#"Test" = if not List.IsEmpty(DateList) then #table(null, {}) else #"Changed Type"
in
#"Changed Type"

dufoq3's avatar
dufoq3
Community Champion
1 year ago

let
Source = Csv.Document(File.Contents("C:\Mydocuments\Test.csv"),[Delimiter=",", Columns=83, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", Int64.Type}, {"Code", Int64.Type}, {"Value", Int64.Type}}),

#"Test" = if not List.IsEmpty(DateList) then #table(null, {}) else #"Changed Type"
in
#"Test"