topic Re: Scripting Question in QlikView

Scripting Question

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

Hi there,

PFA

I would like create a variable which contains a list of BUs and then use it to populate new field. Please see below

Temp:
LOAD [Dynamic Field Source Option ID],
[Dynamic Field ID],
[Dynamic Field Source Option Value],
[Dynamic Field Data ID],
[Audit ID],

if(Match( [Dynamic Field Source Option Value],'RBB','Technology','QA & PP','COO','Functions','CIB','WIMI','RoA Banking'),[Dynamic Field Source Option Value]) as [Internal Audit Team]

FROM $(vPath)\DynamicData_Value.qvd (qvd);

Map_DDField_Value1:
Mapping LOAD [Audit ID] AS [TEMPAudit ID],
[Internal Audit Sub Team]
Resident Temp;

So what I want to do is

LET vBU= (list of values from BU field)

then If(match( [Dynamic Field Source Option Value],$(vBU)) as [Internal Audit Team]

Regards

Re: Scripting Question

kaushiknsolanki — Wed, 24 Jan 2018 09:56:38 GMT

Hi,

You can try this.

One Way:

Load BU from XYZ;

Load *,If(Exists(BU,[Dynamic Field Source Option Value]),BU) as InternalAuditTeam

From xyz;

Second: (Using Variable)

Temp:

Load Concat(DISTINCT BU,',') as BU from XYZ;

Let vBU = Peek('BU',0,'Temp');

Load *, If(Wildmatch([Dynamic Field Source Option Value],$(vBU)),[Dynamic Field Source Option Value]) as InternalAuditTeam

From PQR;

Regards,

Kaushik Solanki

Re: Scripting Question

zwyne — Wed, 24 Jan 2018 10:24:20 GMT

Thank you Kaushik, it gives an this error

I cannot see where I missing a bracket but from the variable created vBu ,it does not misses some apostrophes i.e '

Re: Scripting Question

zwyne — Wed, 24 Jan 2018 11:31:47 GMT

I have figured out the problem. Thank you

Re: Scripting Question

kaushiknsolanki — Wed, 24 Jan 2018 11:52:14 GMT

Perfect.

Regards,

Kaushik Solanki