Concatenate 2 Columns as a prescribed column

[lark9820]

Hi Qlik experts,

I have already created the columns vBreach and vMisconduct, 1 means true and 0 stands for false.

I am wondering if there is possibility to create the third column MNBR for all 1s?

vBreach	vMisconduct	MNBR
1	0	Breach
1	0	Breach
0	1	vMisconduct
1	0	Breach
0	1	vMisconduct
0	1	vMisconduct

Thanks in advance!

[anushree1]

Please try:

Data:
Load *,
pick(Match(vBreach&vMisconduct,10,01,),'Breach','vMisconduct') as MNBR_Test;
Load * Inline [
vBreach,vMisconduct
1,0
1,0
0,1
1,0
0,1
0,1

];

[Brett_Bleess]

If the post you received was what you needed, be sure you return to the thread and on that user's post, use the Accept as Solution button to mark that as the solution, which gives the poster credit for the help and lets other Members know that worked.  

The only other thing I can offer is a Design Blog post that may also be an option to consider:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

Here is the base URL for the Design Blog area for future reference, as there are over 700 posts there, mostly how-to material that should be helpful to you.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett