Discussion board where members can get started with QlikView.
I want to apply lookup and check if field is already added in above table. Please see the details below.
LOAD * INLINE [Cityname Delhi, Pune, Bihar,];
Directory;LOAD place,' here i want to add new field yes or no. if place exists in citynames(in above table) return yes else no FROM[..\..\sample data.xlsx](ooxml, embedded labels, table is Sheet1);
Can anyone please help me to add the expression in load syntax?
Go to Solution.
Try: If(exists(Cityname, place)=-1,'Yes','No') As FieldName
View solution in original post
Try to load your table like see below small example
LOAD * INLINE [
LOAD * Inline [
Cityname as City_name
place as City_name,
'Y' as Flag
'N' as Flag
Resident T2 Where Not Exists(City_name,place);
Then you get output as
Hope this helps
Nilo has it!
Many thanks for your help.
Is it possible to get the count as well?
Hi Sunny, you're welcome.
Do you want count how many 'yes'es and 'no's you've got after load?
In this case you can create a pie chart or a straight table and count(FieldName).