When you're in the script editor and you've selected the Argus Propan 2013.xls file (using the Table Files... button in the script editor) you can enter the File Wizard (by selecting the Next> button).
With a conditional delete you can leave out the row containing Durchschnitt.
Hope this helps.
thanks for your fast reply. I tried the Wizard already - thanks for this tip.
But I forgot to mention that it should be kept variable and all the sheets are updated every day for the curent month yearly.
If I use the wizard, i would have to generate the load every year new (Argus Propan 2014.xls) -> the number of data varies from month to month and from year to year - but the two conditions are always the same.
My idea was it to go thorugh a sheet and check the start condition ('Datum') and the end condition ('Durchschnitt') for each month and load the range between this two conditions.
Thanks & Best Regards,
With the conditional delete - the wizard will always look for the row containing the end condition Durchschnitt.
You can also use a conditional to delete the header rows (or you must make sure always the same amount of header rows are used).
All other rows will be added to your table.
You can use a variable to store the filename.
That way you only have to change the variable once a year.
You can even store this vaiable in a settings-file.
Thank you all for your help,
i've done it like here
See last post from sampath kumar
My solution for this problem:
Argus_Data: LOAD F1 as Datum, Low as CIF_ARA_LARGE_Low, High as CIF_ARA_LARGE_High, Mittelw. as CIF_ARA_LARGE_Avg, [Mittelw. Kum.] as CIF_ARA_LARGE_Avg_Cum, Low1 as FCA_ARA_RAIL_Low, High1 as FCA_ARA_RAIL_High, Mittelw.1 as FCA_ARA_RAIL_Avg, [Mittelw. Kum.1] as FCA_ARA_RAIL_Avg_Cum, Low2 as FOB_ARA_BARGE_Low, High2 as FOB_ARA_BARGE_High, Mittelw.2 as FOB_ARA_BARGE_Avg, [Mittelw. Kum.2] as FOB_ARA_BARGE_Avg_Cum, RecNo() as Range FROM [C:\Users\m006u021\Desktop\Argus Propan 2013.xls] (biff, embedded labels, header is 5 lines, table is September$); max: load max(Range) as ad Resident Argus_Data; let b=Peek('ad',0); drop Table max; let c = Lookup('Range','Datum','Durchschnitt','Argus_Data'); Argus_Propan: NoConcatenate LOAD * Resident Argus_Data Where Range < $(c); //and no< $(d); STORE Argus_Propan INTO $(vQVDPath)\Argus_Propan.qvd; DROP TABLE Argus_Data, Argus_Propan;
Have u an example for your way with the wizard? Probably i need some training with the wizard
Thanks & Best Regards,
I suggest you could it better load with an approach like this:
for each vTabSheet in 'Januar', 'Februar', ... and so on
first 31 // number of max. rows
From [C:\Users\m006u021\Desktop\Argus Propan 2013.xls]
(biff, embedded labels, header is 8 lines, table is $(vTabSheet))
Your table will be a crosstable - perhaps it is a better way this table to convert in a normal table. You could here use the crosstable-wizard. All parts from this suggestion you could find in the manual.