JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have two tables I read into PQ, tbl_Files and tbl_Data
tbl_Data begins:
tbl_Files contains 3 files where path above is found in row 1, 5th column
How can I replace the csv file path with the fixed value in tbl_Files?
TIA,
Jack
I have two tables I read into PQ, tbl_Files and tbl_Data
tbl_Data begins:
Power Query:
let
Source = Csv.Document(File.Contents("C:\Users\JackDanIce\Desktop\Temp\Pillar2 Dev\Static_Data_P2FundLevel.csv"),[Delimiter=",", Columns=42, Encoding=65001, QuoteStyle=QuoteStyle.None]),
tbl_Files contains 3 files where path above is found in row 1, 5th column
How can I replace the csv file path with the fixed value in tbl_Files?
TIA,
Jack