pick match not working

[nareshthavidishetty]

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..

[maxgro]

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?