Forum Discussion

Nahel88's avatar
Nahel88
Frequent Visitor
10 years ago
Solved

Copy Query

I have the following example of my data : Col1        Col2                                                        Col3        Col4 s               1                                               ...
Need Help
Tips and Tricks
Tutorial Requests
  • Baskar's avatar
    Baskar
    10 years ago

    Hi buddy,

    I will give you two ways
    1. from Query editor.
    Original Table









    Using Filter to remove NullModelling Table


    2. From Development Canvas

    Table ViewRemove the check mark inOr else Choose in filter "is not Blank"

wonga's avatar
wonga
Icon for Continued Contributor rankContinued Contributor
10 years ago

Nahel88

 

Assuming columns 1 and 2 are one table and columns 3 and 4 are another table:

 

You can probably use the "Merge Queries" feature in Query Editor and select the common column between the two tables and the result will be only what's common between the two.

 

If my assumption is incorrect, please provide more context/information as to what you want to achieve.

  • Nahel88's avatar
    Nahel88
    Frequent Visitor
    10 years ago

    ya but merge only works with mached type columns and those are two different types so , i dont think thats ganna work 

    • Eric_Zhang's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago
      Nahel88 wrote:

      ya but merge only works with mached type columns and those are two different types so , i dont think thats ganna work 

      Nahel88

       

      According to the snapshots in your original post, I think you can conform the columns to same consitent data types. Afterwards, merge the queries.