How To load multiple files from one folder based on certain conditions

pra_kale — Tue, 24 Jul 2018 17:58:33 GMT

Hi,

I have multiple .csv files saved on one folder but without column headers which i want to load at a one time.

Folder is available on..E:\Qlikview\TEST

Below given are the conditions..

1) Column Headers are available in another excel file...HEADER.xlsx..These column names are required at the top and in the same order.

2) Product Name file contains initials of all the products. By these initial names only files are get's saved on a path..Product_code.xlsx

3) What ever products are available on Product_code files only these files should get imported...

for e.g. Product_code file contains CNTTYPE as GCDPP, GCP1 and GNN and where as files available on folder like GCDPP_001, GCP1_001, GCP1_002, GKL_001 and GNN_001. first word before _ is product name. so only GCDPP_001, GCP1_001, GCP1_002 and GNN_001 files should get imported. GKL_001 file should not get imported because GKL product code is not available in Product_code file.

4) Under Remark column file name is required from which data get's imported.

Your Help is appreciated...

Thanks in Advance

stalwar1‌

marcus_sommer‌

topic How To load multiple files from one folder based on certain conditions in QlikView

How To load multiple files from one folder based on certain conditions