Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Prabhu1204
Creator
Creator

Fetch the undefined values in table 1 from table 2

I have two tables.

Action is a static table (Below is the table)

 

Action.PNG 

 

Prabhu1204_0-1603013430154.png

Expected output
  
IDAction
3sales in progress
4In progress
 
 

 

the second table should have only the values defined in the table 1. So i need to fetch the values that are not defined in the table one.

Suggestions required

-Prabhu
Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@Prabhu1204  try below. make sure that field name of Action in table1 should be same as table2. If not then rename Action of Table1 as same as table2.

 

 

Table1:
LOAD Action
FROM Table1;

Table2:
LOAD ID,
     Action
FROM Table2
where not exists(Action);

drop table Table1; 

 

 

 

View solution in original post

5 Replies
Prabhu1204
Creator
Creator
Author

 @sunny_talwar , can you suggest some idea

-Prabhu
Kushal_Chawda

@Prabhu1204  try below. make sure that field name of Action in table1 should be same as table2. If not then rename Action of Table1 as same as table2.

 

 

Table1:
LOAD Action
FROM Table1;

Table2:
LOAD ID,
     Action
FROM Table2
where not exists(Action);

drop table Table1; 

 

 

 

Prabhu1204
Creator
Creator
Author

@Kushal_Chawda Thanks a lot Kush... Thank you so much, i never knew that i have to drop the table 1...

 

But one question, I dont have ID field in table 1. In that case can I use Action field instead of ID

-Prabhu
Kushal_Chawda

@Prabhu1204  i meant to be action only but ID was typo

Prabhu1204
Creator
Creator
Author

Thank you.. you always rock 

-Prabhu