Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
How can i write Where Exists condition in qlikview by using "AND" can any one give with Example ?
Regards,
Mahesh
try
load
a,b,c
resident Test
where exists(a) and (b='1')
load all data where datarow with a laready loaded and b contains value 1
Hi Bro,
Here Data like this
T1:
DATE
Jan
Feb
Mar
T2:
DATE1
Jan
Feb
Mar
Apr
Jul
Here i want matching months dynamically
Regards,
Mahesh
Hi,
you can try like this:
T1:
LOAD DATE FROM [mySource1];
T2:
Load DATE1 FROM [mySource2] WERE EXISTS(DATE,DATE1 );
Hope this helps.
Kind regards,
T1:
load * inline [
DATE
Jan
Feb
Mar
];
T2:
load * Inline [
DATE1
Jan
Feb
Mar
Apr
Jul
];
Test:
NoConcatenate
load DATE1
Resident T2
where Exists(DATE,DATE1)
gets you this result (is it what you want?)
Hi All,
I have Date field i changed to month i done how you guys said but i am not getting
Regards,
Mahesh
cyn aou post sampe qvw?
are the monthfield in two tables are same Format?
While reloading time also Where condition table lines showing fetching zero lines
if i remove the where condition lines fetching started
Do you have month fields as the same thing? I mean may be one month is dual field created using Month() function and the other one is text created inline may be?