Copy Query

[Nahel88]

I have the following example of my data :

Col1        Col2                                                        Col3        Col4

s               1                                                               s             1

q              2                                                               q             2 

d                                                                                f             3

f               3                                                                h            4 

g

h              4 

j

 and i want to get only the rows that both Col1 and Col2 are existin other words Col3 and Col4. I need the Query to get such a result sorry im not that good in writing queries but im in need to get this one. 

[Baskar · Accepted solution]

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]

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

[SabineOussi]

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.

[wonga]

@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]

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

[Eric_Zhang]

---

@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.

[Baskar]

Hi Nahel let me know , what is the output u excpecting ?

[Nahel88]

the Col3 and Col4 so a 2 new Columns