Dear Mynda,
Let me know if you could help me with some Power query tips:
In my source file "Occ Angra 2016 09 23.xlsx" I have information in 2 specific lines where is written "031 - GOLDEN TULIP ANGRA DOS REIS" (Hotel name) and in line 25 we have the day and the hour wich was created the file. This two information are very important to me and my goal is to create three new columns. One with the name of the hotel and the others with the date and hour of the report.
Hotel Name Day Created Hour Created
Your help would be very precious.
Attached you will find my query file where I have already started with PQ transforming the data.
Thanks a lot
José Ricardo
Hi José,
Your file isn't attached. After 'adding the files' you have to click the 'start upload' button to actually upload it.
Mynda
Dear Mynda
I hope all is well with you.
As I found one solution to solve my problem I think it is a good idea delete this posts.
Thanks
José Ricardo
