This content has been marked as final.
Show 3 replies
-
Re: Column Row relation in QV
Dennis Hoogenboom Oct 13, 2011 6:12 AM (in response to Moreed Murrar )Does this help:
Input: LOAD RecNo() as Key, Dim1, Code, Val1 FROM Example1.xlsx (ooxml, embedded labels, table is Input1); Input2: Load RecNo() as Key, Dim2, Val2 FROM Example1.xlsx (ooxml, embedded labels, table is Input2);
?
This way the information in the different sheets are connected based on the row number.
-
Column Row relation in QV
Moreed Murrar Oct 13, 2011 8:58 AM (in response to Dennis Hoogenboom )Dear Dennis,
unfortunatly this didnt help!
regards,
Moreed
-
Re: Column Row relation in QV
Dennis Hoogenboom Oct 14, 2011 6:11 AM (in response to Moreed Murrar )Hi Moreed,
It doesn't make sence to me because the values (the calculations are different for the codes.
But maybe you can start with this:
Input: LOAD Dim1, Code, Val1 FROM Example1.xlsx (ooxml, embedded labels, table is Input1); //Input2: Join (Input) Load Dim2, Val2 FROM Example1.xlsx (ooxml, embedded labels, table is Input2); Input2: Load * , ((Val1) * (Val2)) as Val4 Resident Input; Drop table Input;
Like I said it doesn't make sence to me.
Maybe I can help you better is you can explain what it is you are trying to do. What your data is.
-
-