excel - Join a path variable to each row in the import csv file -

i have many import files,

so there sales values per team member, no period inside.

the period coded in path like:

alldata\201501\revenues.txt alldata\201502\revenues.txt alldata\201503\revenues.txt 

i want have periode path on each data row, final output table should this:

so must bring period path inside file anyway.

the question how access path solved in perfect example here:

how can save path criteria when import folders?

but there have still period on "whole" text, not on row.

in linked question can change custom column formula from:

text.frombinary([content])

to

text.split(text.frombinary([content]), "#(000a)") (depending on how line breaks represented, may need use "#(000a)#(000d)" instead).

this split text @ each new line, , you'll list of name;value pairs. click on box 2 arrows next column name expand column. each row should have period associated name;value pair. finally, split column delimiter on semicolon separate name value.