Greetings,
I'm working on a conditional output, that will swich output table (if it's empty) to the predefined one. The code goes as:
#"Filtered Rows4" = Table.SelectRows(#"Added Custom3", each ([Custom] = "Object missing")),
Test = Table.IsEmpty(#"Filtered Rows4"), // returns TRUE, as logical value type I guess
TestOKTable = Table.FromRecords({[Message = "OK"]}),
Output = (if Test = "TRUE" then TestOKTable else #"Filtered Rows4") //no matther what, always returns #"Filtered Rows4" with 0 rows
in
Output
I'm looking for a hint what am I doing wrong, tried the Output = (if Test = TRUE then TestOKTable else #"Filtered Rows4") but returns error, seems I'm not able to properly refer to the TRUE result.
EDIT: the solution was simple, to refer properly to logical value is was required to write the code as:
Output = (if Test = true then TestOKTable else #"Filtered Rows4") // lower case need to be used without quotation
Case resolved....
Would appreciate any feedback.
