Forum Discussion
Trying to expand binary content
Hi, Is there any other way to expand this content, because if i click on expand icon besides Content, then it is not working
Combining Binary files:
I know how to do it by adding a custom column for
csv files =Csv.Document([Content])
or
Excel files = Excel.Workbook([Content])
But, what about .txt files?
Is there a command that does the same as above"?
my reasoning:
I HATE those auto-created transformation files, and I like to keep certain columns to identify dates or original source, which the first to allow me to do, but the Combine button removes.
A .csv file is actually a ".txt" file. CSV just stands for comma seperated values. So you can use the same function (Csv.Document()) for your other files. You might have to check how the values are seperated in your files. Maybe it is by a Tab instead of a comma.
Note that when you expand the "Content" column all column names will be hardcoded in the query. Just wanting to let you know that there is a way around that by first saving all the column names in a variable and then putting this variable into the Expand function as an argument.
You can check the documentation for this function here to see what the other arguments of the function do: