Concatenating Binary column with Date column

[Guinaba]

Hi experts,

I am using powerquery to extract multiple files from a folder and I'd like to add a date column to identify each file after opening up all of them. If I explode the content column I don't get the dates.

Does anyone know a way to do that?

Gill

 

[arunsjain]

Hi,

When you click on double down arrow, query append all files and create four steps:

a) Filtered Hidden Files
b) Invoke Custom Function
c) Remove Other Columns
d) Expanded Table Column

Go to third step c) 'Remove Other Columns and add manually date column in it. Refer to screenshot. Date column will appear as last column in expanded table.

I hope it will help.

Cheers!!!

 

[Guinaba]

Hi,

When you click on double down arrow, query append all files and create four steps:

a) Filtered Hidden Files
b) Invoke Custom Function
c) Remove Other Columns
d) Expanded Table Column

Go to third step c) 'Remove Other Columns and add manually date column in it. Refer to screenshot. Date column will appear as last column in expanded table.

I hope it will help.

Cheers!!!

Thanks @arunsjain!! Awesome!​