loop table icm store

PHOTO EMBED

Mon Aug 19 2024 05:58:21 GMT+0000 (Coordinated Universal Time)

Saved by @bogeyboogaard

let vLoopTablecommaCount=SubStringCount(vTables,',');

trace $(section) finnal vTables $(vTables);

for i=2 to vLoopTablecommaCount + 1    

  let t = subfield(vTables,',', i);

  trace $(1) loop store met t $(t);


  HTM_RESET:
  NoConcatenate
  LOAD Null() AS DummyField
  AUTOGENERATE 0;


  STORE HTM_RESET INTO [$(vEnvironmentPathQvd)/$(t).qvd] (qvd);

  LET vRows = NoOfRows('$(t)');
  TRACE $(t) has $(vRows) rows;

	STORE $(t) INTO [$(vEnvironmentPathQvd)/$(t).qvd] (qvd);
    
      
  drop table  $(t);

next

content_copyCOPY

https://htm-rapportage.eu.qlikcloud.com/dataloadeditor/app/9e01ce59-e241-41dc-aca1-5490cddba9c2/hubUrl//catalog