Using a Separate File to Control Filtering

m_perreault — Tue, 08 May 2018 15:38:58 GMT

Hi All,

I have created a QVD which is to be used by a series of end user's who at times will need to apply Where Clauses for 20+ values on a particular ID field. I am trying to think of a way to allow them to do this without writing out a long Where (MATCH,ID,'1',....'20'). My initial idea was at the same time the QVD is created I created a CSV file with all values for the ID field and 'N' as Include. See below

Export:

Load *
Resident test;

Drop table test;

Store Export [file.qvd] (qvd);

NoConcatenate
ID_Filters:
Load Distinct

ID,

'N' as Include

Resident Export;

Drop table Export;

Store ID_Filters into [file.csv] (txt);

This would allow End User to open the CSV file and for the ID's they want to include set the value to Y then when loading the QVD they would do.

Table1:

Load *
From File.qvd(qvd);

Inner Join(Table1)

Load *
From file.csv

Where Include = 'Y';

The problem I am having is when I open the csv file in Exel and make any changes then save the CSV file it becomes one column.

Does anyone have any other ideas of how to accomplish what I am trying to do?

Thanks,
Mark

Re: Using a Separate File to Control Filtering

m_perreault — Tue, 08 May 2018 23:21:35 GMT

I seem to have found a work around solution. I found a macro script here which allows for quick conversion of CSV files to XLSX files here Excel VBA convert CSV to Excel

topic Re: Using a Separate File to Control Filtering in App Development

Using a Separate File to Control Filtering

Re: Using a Separate File to Control Filtering