Forum Discussion
Copy Query
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.
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"
8 Replies
- Baskar
Resident Rockstar
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" - BaskarHi Nahel let me know , what is the output u excpecting ?
the Col3 and Col4 so a 2 new Columns
wongaContinued Contributor
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.
ya but merge only works with mached type columns and those are two different types so , i dont think thats ganna work
- Eric_Zhang
Microsoft Employee
carinatAdvocate II
Do you want to keep col 1 and 2 or could you simply just filter out blank values in both columns?
SabineOussiSkilled Sharer
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.