Hello everyone.
I have an .xlsx file which i treat using Power Query to generate a table in another .xlsx file from which I recover information and feed PowerBI visuals. I would like to know if it's possible do add a "field" (in practical terms, a cell) to each row that behaves like a database field. Those tables contain workers information that can change in time. I'll try to illustrate:
Original base file (generated from specific database system):
| Random system info | Random system info | Random system info | | |
| | | Random system info | Random system info | Random system info |
| Name | Hiring date | Title | Unnecessary info | Unnecessary info |
| Name 1 | 01/01/2000 | Manager | sd23rfse3 | 65j1yt56tjt |
| Name 2 | 02/02/2000 | Assistant | 98798kgjh98k | 65as4d56sa |
Transformed file:
| Name | Hiring date | Title |
| Name 1 | 01/01/2000 | Manager |
| Name 2 | 02/02/2000 | Assistant |
Info I would like to have:
| Name | Hiring date | Title | Workplace |
| Name 1 | 01/01/2000 | Manager | Address 1 |
| Name 2 | 02/02/2000 | Assistant | Address 2 |
First I thought of just creating a new column on the table, but it came to my mind that when the data changes, the information probably will be displaced. I also thought of creating a conditional column in Power Query, but i'm dealing with hundreds of rows, it would end up being so cumbersome even the first idea sounded better. And for some nonsense reason I was told that the most oubvious, which is including the info already in the database system, won't be done.
So is it possible o achieve this with Power Query? Thank you in advance for any help!
