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"

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.