Forum Discussion
Advocate ITrouble merging queries & tables
HI Bhavesh
I tried a different route, which involved using the header file, leaving the headers as row 1, then appended the data (so row 1 was the header names I required and the column was called column 1, the same as it is in the data file). The appended data was then there, and THEN I promoted the first row to headers, so my row1 header data was now in the right place and all was working.
Many thanks for the efforts to assist, I guess there are many ways to achieve the results required, sometimes it just needs a fresh approach.:smileyvery-happy:
Advocate II wish it was so simple, when I select append it adds the 31 coumns to the end as extra columns( so I have 31 column headers, then column1...column31), then populates my existing table with the first 31 columns of null all the way accross until it reaches "column1" and also creates records all the way down. I am still new to the Power BI space, so maybe there is something simple I am missing
Super UserHi There,
There are simple ways of filteration of null values and some other options as well. Can you please upload your sample file so I can guide you step by step process of achieving the final results.
Thanks & Regards,
Bhavesh
- darynv_za
Thanks for the offer, here is a small subset. the S_File is the headers, which I can remove the columns I don't need, then transpose so I am left with the headers I require(column called FIELDNAME) the other file is the data with no headers. So basically once I have the Query for the headers cleaned there is only DOC_Number....CML_CD_QTY, no values, and I then need to join the data (in the same order) to the query, but all the options I try do not give me the required results.
- darynv_za
HI Bhavesh
I tried a different route, which involved using the header file, leaving the headers as row 1, then appended the data (so row 1 was the header names I required and the column was called column 1, the same as it is in the data file). The appended data was then there, and THEN I promoted the first row to headers, so my row1 header data was now in the right place and all was working.
Many thanks for the efforts to assist, I guess there are many ways to achieve the results required, sometimes it just needs a fresh approach.:smileyvery-happy: