Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
please post expected output related to your sample data.
thanks
regards
Marco
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