Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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?