Table store

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Table store

stascher — Wed, 28 Feb 2018 18:01:31 GMT

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;