Hi All,
I know this will be simple you the QV guru out there and thanks in advance.
I have an inline table with 3 field. I will like to multiply in field in inline table with another resident field and repeat this 10 time to produce a new table.
So here is the data
Table1:
Key,
Key2
Key3
from xxxx;
Adjustment_Percentage:
LOAD * INLINE [
Weighting, Initial - headcount, Initial - percentage, Normalised excluding non-daily readers, Adjustment for survey hits
A, "1,198", 23.7%, 44.0%, 44.0%
B, 365, 7.2%, 13.4%, 13.4%
C, 53, 1.0%, 1.9%, 1.9%
D, 107, 2.1%, 3.9%, 3.9%
E, 12, 0.2%, 0.4%, 0.4%
AB, 277, 5.5%, 10.2%, 5.1%
AC, 38, 0.8%, 1.4%, 0.7%
AD, 29, 0.6%, 1.1%, 0.5%
AE, 5, 0.1%, 0.2%, 0.1%
BC, 46, 0.9%, 1.7%, 0.8%
BD, 111, 2.2%, 4.1%, 2.0%
BE, 49, 1.0%, 1.8%, 0.9%
CD, 21, 0.4%, 0.8%, 0.4%
CE, 1, 0.0%, 0.0%, 0.0%
DE, 31, 0.6%, 1.1%, 0.6%
ABC, 46, 0.9%, 1.7%, 0.6%
ABD, 43, 0.8%, 1.6%, 0.5%
ABE, 35, 0.7%, 1.3%, 0.4%
ACD, 13, 0.3%, 0.5%, 0.2%
ACE, 1, 0.0%, 0.0%, 0.0%
ADE, 10, 0.2%, 0.4%, 0.1%
BCD, 35, 0.7%, 1.3%, 0.4%
BCE, 3, 0.1%, 0.1%, 0.0%
BDE, 65, 1.3%, 2.4%, 0.8%
CDE, 8, 0.2%, 0.3%, 0.1%
ABCD, 22, 0.4%, 0.8%, 0.2%
ABCE, 5, 0.1%, 0.2%, 0.0%
ABDE, 40, 0.8%, 1.5%, 0.4%
ACDE, 2, 0.0%, 0.1%, 0.0%
BCDE, 26, 0.5%, 1.0%, 0.2%
ABCDE, 24, 0.5%, 0.9%, 0.2%
];
So I will like to Multiply Key with Adjustment for survey hits.
Thanks attached is the data