Store one table into multiple files

jono19872002 — Sat, 16 Nov 2024 00:55:15 GMT

I have a table split by Customers which store into a CSV format ready to send out.

Is there a way that i dynamically can split this table into multiple CSVs based on the customer column.

For example i could manually Load into individual tables with a where clause, store then drop etc, but I want this to be a dynamic process if possible

Re: Store one table into multiple files

lironbaram — Thu, 02 Apr 2020 11:55:13 GMT

assuming your table is called Data

you could write a script like this :

///loading the data

Data:

Load *

From source ;

//////loading distinct values of customers

customers:

load distinct Customer

resident Data;

///looping through customers and saving a csv for each customer

for i = 0 to noofrows('customers')-1

let vCustomer = peek('Customer',$(i),'customers');

customerTable:

noconcatenate Load

Resident Data

where Customer = '$(vCustomer)';

store customerTable into [lib://customerFiles(admin)/customerTable_$(vCustomer).csv](txt);

drop table customerTable;

drop table customers;

topic Re: Store one table into multiple files in QlikView

Store one table into multiple files

Re: Store one table into multiple files