Forum Discussion

darynv_za's avatar
darynv_za
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Trouble merging queries & tables

I have two queries, one containing data and one containing the header data (column names but no data) for the data ( an SAP extract) I can format the one to get the data to be the column headers, I t...
  • darynv_za's avatar
    darynv_za
    10 years ago

    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:

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

Hi 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's avatar
darynv_za
Icon for Advocate I rankAdvocate I
10 years ago

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: