Table store

[subbareddykm]

HI All ,

How to divide my table based on State Field and create the QVD's corresponding statename Qvd's with single load and store statements.

[stascher · Accepted solution]

States:

load distinct State from Sample.xlsx (ooxml, embedded labels, table is Sheet1) ;

for each state in fieldvalueList('State')

Temp:

  load * from Sample.xlsx (ooxml,embedded labels,table is Sheet1) where State='$(state)';

  store Temp into [OutFile_$(state).qvd]; // change to your desired output file name template.

  drop table Temp;

next state;

drop table States;