Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can I load single excel file in two script?
SALE is the excel file and I want to load as below
In hidden script
Field1
Field2
Field3
In normal script
Field4
Field5
Field6
But need all Field shold be available in SALE table...
Hi,
Please find the attachment. Use the same password.
Hope that helps.
- Khaled.
Hi,
You can do this by splitting the table on a Key field. For example, in the Hidden script you can have:
Sales:
Load
* inline
[
Value
101
102
103
];
In the normal script, you can write:
Load
* inline
[
Value
106
104
105
];
For a little more detail,
In the hidden script, you can have Field1
SalesXY:
Load * inline
[
Key,Field1
101,A
102,B
103,C
];
In the hidden script, you can have Field2
Upon reload, the SalesXY table will should all the fields.
Please find attachment (password for hidden script is 123456). Is that what you are looking for ?
-Khaled.
-Khaled.
Dear Khaled,
Thanks for your response.
My mistake, haven't explain query in proper way.
Please find attached excel file.
What I want...
In hidden script
load Invoice No and Invoice Date only
In Normal script
Load Part NO, QTY, Price (INV)
Basically want to hide Inovice No and Invoice Date...!!!
Final outcome should be like below.
Invoice No | Invoice Date | Part NO | QTY | Price (INV) | Inv Total |
Inv 001 | 25/09/12 | Part 001 | 20 | 7.00 | 140.00 |
Inv 001 | 25/09/12 | Part 002 | 4 | 50.92 | 203.68 |
Inv 001 | 25/09/12 | Part 003 | 7 | 63.98 | 447.86 |
Inv 002 | 30/09/12 | Part 004 | 1 | 195.16 | 195.16 |
Inv 002 | 30/09/12 | Part 005 | 5 | 252.14 | 1260.70 |
Inv 003 | 01/10/12 | Part 006 | 12 | 84.31 | 1011.72 |
Inv 003 | 01/10/12 | Part 007 | 2 | 72.65 | 145.30 |
Inv 003 | 01/10/12 | Part 008 | 6 | 104.01 | 624.06 |
Inv 003 | 01/10/12 | Part 009 | 35 | 15.36 | 537.60 |
Inv 003 | 01/10/12 | Part 010 | 3 | 28.85 | 86.55 |
Inv 003 | 01/10/12 | Part 011 | 16 | 10.29 | 164.64 |
Inv 004 | 05/10/12 | Part 012 | 66 | 10.12 | 667.92 |
Inv 004 | 05/10/12 | Part 013 | 75 | 12.00 | 900.00 |
Inv 005 | 20/10/12 | Part 014 | 3 | 361.51 | 1084.53 |
Hi,
Please find the attachment. Use the same password.
Hope that helps.
- Khaled.
It's working... Thanks for your help.