Scripting Question

[zwyne]

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

[kaushiknsolanki]

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

[zwyne · Accepted solution]

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 '

[zwyne]

I have figured out the problem. Thank you

[kaushiknsolanki]

Perfect.

Regards,

Kaushik Solanki