Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Exprerts,
I have one urgent requirement please help me on this. I have two fields one WAVE and DISTRICT fields
wave | District |
---|---|
wave1 | prakasam |
wave1 | guntur |
wave1 | Eastgodavari |
wave1 | westgodavari |
wave2 | prakasam |
wave2 | guntur |
wave2 | Eastgodavari |
Expected result :
wave | District |
---|---|
wave1 | prakasam |
wave1 | guntur |
wave1 | westgodavari |
wave2 | prakasam |
wave2 | guntur |
wave2 | Eastgodavari |
here i have to filter the Eastgodavari district data from Wave1 which is also available in wave 2. That means we don't want wave1 data from Eastgodavari district
please give me any suggesion.
thanks for advance.................................
Why Can't you simply do this? I seriously omit to do this. Could be some reasons I've doing hard code
LOAD wave,
District
FROM
[https://community.qlik.com/message/1283467]
(html, codepage is 1252, embedded labels, table is @1) Where Not WildMatch(wave, 'wave1') or Not WildMatch(District, 'Eastgodavari');
Expected result?
Hi Anil Babu,
thanks for reply below are the expected reslult.
wave | District |
---|---|
wave1 | prakasam |
wave1 | guntur |
wave1 | westgodavari |
wave2 | prakasam |
wave2 | guntur |
wave2 | Eastgodavari |
In back end
where wave <> 'wave1' and District <>'Eastgodavari'
Why Can't you simply do this? I seriously omit to do this. Could be some reasons I've doing hard code
LOAD wave,
District
FROM
[https://community.qlik.com/message/1283467]
(html, codepage is 1252, embedded labels, table is @1) Where Not WildMatch(wave, 'wave1') or Not WildMatch(District, 'Eastgodavari');
And won't work, Should be in OR operator
PFA..
Thanks for giving support Anil Babu........it is working for me thank you very much
.