pick match not working

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have used below logic in script but it is not working.

Qlik version : 12

Logic: Pick(Match([Conformed Cause Code],'Vendor - Suspect MCP'),'Vendor') as [Conformed Cause Code]

Please let me know if ts there any other approach.

Thanks..

Re: pick match not working

maxgro — Tue, 25 Sep 2018 11:08:03 GMT

It seems to work without any syntax error

tmp:

load * inline [

Conformed Cause Code, Field

Vendor - Suspect MCP, 1

Other, 2

];

tmp2:

NoConcatenate load

Pick(Match([Conformed Cause Code], 'Vendor - Suspect MCP'),'Vendor') as [Conformed Cause Code],

Pick(WildMatch([Conformed Cause Code], 'Vendor - Suspect MCP', '*'), 'Vendor', [Conformed Cause Code]) as [Conformed Cause Code 2]

Resident tmp;

May be you want a different result?