I m trying to use source string from a variable and i m getting an error that i can not convert string to list.
I have the below step as source:
= Table.Combine({#"File 2023", #"File 2024", #"File 2025"})
I create a table and import this the below string as a value
{#"File 2023", #"File 2024", #"File 2025"}
Variable called cnsList
created and the string succesfully passed into the variable.
When i use = Table.Combine(cnsList)
i get the error that i can not use text as list.
Any ideas?
Create a blank query and paste:
={#"File 2023", #"File 2024", #"File 2025"}
This will generate a list. Rename the list to FileList
. Use as follows:
= Table.Combine(FileList)