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"

carinat's avatar
carinat
Icon for Advocate II rankAdvocate II
10 years ago

Do you want to keep col 1 and 2 or could you simply just filter out blank values in both columns?

SabineOussi's avatar
SabineOussi
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

I think Nahel wants to remove blanks values from columns 1 and 2 in order to obtain something similat columns 3 and 4.

 

Create your table with columns 1 and 2, under Filters (right pane), expand column 2 and select is not blank, apply the filtering and this should remove all blank values.