Hi All
i've an excel sheet for the month of Jan (till now, we're in Feb) having 3 cols. I 've created 2 Crosstables from it
Tab1: Crosstable(A,B,6) Load keycol, other_cols from excel_sheet;
Tab 2: Crosstable(C,D) Load keycol ,other_cols from excel_sheet;
Everything is fine & in the table structure they're joined by the keycol.
But i've two questions:
1) In future when the month of Feb till Dec data excel sheets arrive,how to accomodate them in the application, keeping in mind auto collection/incrementing of data from every month's sheet.
2) If i had a single sheet (w/o any Month specific) such that the data is added in that sheet periodically, then how can i make a qvd from this script ? & joining it with the new data to have an incremental load.
Thanks