topic Re: Scripting loop problem in QlikView

Scripting loop problem

Tue, 09 Aug 2016 11:14:44 GMT

Hi,

I hope I can explain this right, let me know if it seems confusing.

I have a long list of adjustments to data. I want to see if the adjustments are linked to a case.

I have an excel sheet, which states the cases and conditions that would make the adjustment linked to that case.

If you look at the excel sheet, an adjustment is linked to the case if the stated attribute of the adjustment is equal to the value.

And all conditions for that case are met. (as you will notice there are multiple conditions for an adjustment to relate to some cases).

If the adjustment is linked to a case, I would then like to add that case as an attribute of the adjustment.

I was wondering how this would be implemented in the qlikview script?

The pseudo code would be something like this:

For adjustment in table:

for case in excel table:

if adjustment attributes = values for all conditions:

adjustment.case = case

Hope someone can help,

Thanks Ben

Re: Scripting loop problem

MarcoWedel — Tue, 09 Aug 2016 23:03:22 GMT

please post expected output related to your sample data.

thanks

regards

Marco

Re: Scripting loop problem

Wed, 10 Aug 2016 08:18:05 GMT

Adjustment	Y	B	C	T	R	Case
1	ZZ	FG	CV	-	-	1
2	-	-	-	A	B	5

This is what the adjustment table would look like (except with a lot more adjustments, and a lot more different attributes. The output I want is for it to add a case attribute to an adjustment row where the adjustment meets the criteria of a case from that excel table.

Thanks,

Ben