topic indirection - use of for each? in Healthcare

indirection - use of for each?

Wed, 28 Aug 2024 16:07:25 GMT

I have a qvd file containing 999 records (customer number and name), i wish to create 999 unique files

containing a directional label (customer name), I am struggling ... any ideas?

swuehl — Sun, 30 Oct 2016 12:18:36 GMT

Maybe something like

List:

LOAD DISTINCT CustomerName as CustomerNameList

FROM QVDFile.qvd (qvd);

FOR EACH name IN FIELDVALUELIST('CustomerNameList')

SingleName:

LOAD '$(name)' as CustomerName

AUTOGENERATE 1;

Extract:

LOAD * FROM QVDFile.qvd (qvd)

WHERE EXISTS(CustomerName);

STORE Extract INTO [Customer_$(name).qvd] (qvd);

DROP TABLE Extract, SingleName;

NEXT name

DROP TABLE List;

Sun, 30 Oct 2016 15:19:33 GMT