Script help!!!

[amit_saini]

Hi Folks ,

I'm having 6 qvds as below:

latencytime_inst1.qvd

latencytime_inst2.qvd

latencytime_inst3.qvd

Responetime_inst1.qvd

Responetime_inst2.qvd

Responetime_inst3.qvd

and across all these qvd's I'm having below table (Columns name are same )----> We can make this as cross table

I have to create a table chart like above , but based on filters below:

Please suggest how this could be possible.

Thanks,

AS

[jonathandienst]

Like this, perhaps:

Set vPath = ..... path to your qvd files ....;

For Each vName in 'latencytime_', 'Responetime_'

  For Each vFile in FileList(vPath & '\' & vName & '*.qvd')

  T_Results:

  CrossTable(Location, Value)

  LOAD *

  FROM [$(vFile)] (qvd);

  Next

  Results:

  LOAD *,

  SubField('$(vFile)', '\', -1) As SourceFile

  Resident T_Results;

  DROP Table T_Results;

Next

The final Results table will have these fields: STDATE, Location, Value, SourceFile

[tresesco]

Try like:

Load

          *,

          SubField(FileBaseName(), '_',1) as Filter1,

          SubField(FileBaseName(), '_',2) as Filter2

From <> ;

[amit_saini]

Hi Jonathan,

Thanks , but below are my qvd's

But after loading the script source file is showing me 2 qvds , it should show all qvds in list box. Please suggest why???

Thanks,

AS

[amit_saini]

Below is script:

Set vPath = D:\qvdev\PLM\Latency Report\#Source\Qvd;

For Each vName in 'latencytime_*', 'responsetime_*'

  For Each vFile in FileList(vPath & '\' & vName & '*.qvd')

  T_Results:

  CrossTable(Location, Value)

  LOAD *

  FROM [$(vFile)] (qvd);

  Next

  Results:

  LOAD *,

  SubField('$(vFile)', '\', -1) As SourceFile

  Resident T_Results;

  DROP Table T_Results;

Next

[amit_saini]

any suggestions????

[amit_saini · Accepted solution]

I Tried this :

Set vPath = D:\qvdev\PLM\Latency Report\#Source\Qvd;

For Each vName in 'latencytime_inst1_8080', 'latencytime_inst2_8070','latencytime_inst3_8060','responsetime_inst1_8080','responsetime_inst2_8070','responsetime_inst3_8060';

  For Each vFile in FileList(vPath & '\' & vName & '.qvd')

This is working fine .

Thanks,

AS