topic Re: condition based dimension in script in QlikView

condition based dimension in script

viveksingh — Sat, 16 Nov 2024 01:55:58 GMT

HI Experts,

I have a data like below

if you observe in the above, Description have different values. Based on a particular value(Failed) all the values of description should be Failed for ABC01 value else it should be Success.

Below is the expected for reference

I want to derive in load script. Please share your comments.

Thanks in advance.

Re: condition based dimension in script

Marcos_rv — Fri, 15 Nov 2019 15:51:28 GMT

try this:
MAIN:
load
name, description
from MAIN.QVD;

aux_1:
LOAD
name ,
if ( wildmatch(aux , 'Failed' ) > 0 ) , 'Failed' , 'Success' ) status_1;
LOAD name , concat(description) as aux
resident main
GROUP BY name ;

left join (MAIN)
load name , status_1 as status
resident aux_1;
drop table aux_1;

saludos!!!

Re: condition based dimension in script

viveksingh — Sun, 17 Nov 2019 13:11:28 GMT

Thanks for the reply. But this is not working as expected.

Can help to provide another type of solution/work around please.

Re: condition based dimension in script

Brett_Bleess — Tue, 19 Nov 2019 22:49:53 GMT

Vivek, you would need to use Group by or Order by in the load and then use the Peek() function I believe to check for that string and if you hit it, then 'map' the other status values all to Failed at that point, but I am afraid I cannot code this for you, only point you in the right direction. Someone else may still chime in though, as my comment will kick things back up in the list again, so maybe someone else will be able to share some code, but you could also search prior posts, as I am pretty sure you will find some examples out there that will help you get things right on this one, as this is fairly comment scenario. Sorry I do not have better for you.

Regards,
Brett

Re: condition based dimension in script

Arthur_Fong — Wed, 20 Nov 2019 03:48:22 GMT

In load script:

Data:

load *, if(Name='ABC 01','Failed','Success')as Status

resident <YourTableName>;

drop table <YourTableName>;