topic Re: Load several CSV Files where name begins with.. in QlikView

Load several CSV Files where name begins with..

qlikviewaf — Tue, 12 Sep 2017 07:39:26 GMT

Hi Guys,

there's a way to load all csv files that have as name SALES_INTERNATIONAL_ instead of creating new script for each year?

Thanks

here my script:

LOAD RECORD_NO,

COMPANY,

CUSTOMER_NO,

YEAR,

MONTH,

ITEM_NO,

QUANTITY,

EXTENDED_PRICE_AMT_LCL

FROM

[\\vmbis\HotFiles\SALES_INTERNATIONAL_2017.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

LOAD RECORD_NO,

COMPANY,

CUSTOMER_NO,

YEAR,

MONTH,

ITEM_NO,

QUANTITY,

EXTENDED_PRICE_AMT_LCL

FROM

[\\vmbis\HotFiles\SALES_INTERNATIONAL_2016.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Load several CSV Files where name begins with..

prieper — Tue, 12 Sep 2017 07:42:02 GMT

use the "*" in the filename:

LOAD RECORD_NO,

COMPANY,

CUSTOMER_NO,

YEAR,

MONTH,

ITEM_NO,

QUANTITY,

EXTENDED_PRICE_AMT_LCL

FROM

[\\vmbis\HotFiles\SALES_INTERNATIONAL_*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Load several CSV Files where name begins with..

Anil_Babu_Samineni — Tue, 12 Sep 2017 07:42:37 GMT

May be use * like below

LOAD RECORD_NO,

COMPANY,

CUSTOMER_NO,

YEAR,

MONTH,

ITEM_NO,

QUANTITY,

EXTENDED_PRICE_AMT_LCL

FROM

[\\vmbis\HotFiles\SALES_INTERNATIONAL_*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Load several CSV Files where name begins with..

karthikoffi27se — Tue, 12 Sep 2017 07:42:52 GMT

Hi Antonio,

Please use the below script

LOAD

RECORD_NO,

COMPANY,

CUSTOMER_NO,

YEAR,

MONTH,

ITEM_NO,

QUANTITY,

EXTENDED_PRICE_AMT_LCL

FROM

[\\vmbis\HotFiles\SALES_INTERNATIONAL*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Many Thanks

Karthik

Re: Load several CSV Files where name begins with..

shraddha_g — Tue, 12 Sep 2017 07:42:59 GMT

Try

LOAD RECORD_NO,

COMPANY,

CUSTOMER_NO,

YEAR,

MONTH,

ITEM_NO,

QUANTITY,

EXTENDED_PRICE_AMT_LCL

FROM

[\\vmbis\HotFiles\SALES_INTERNATIONAL_*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Load several CSV Files where name begins with..

Kushal_Chawda — Tue, 12 Sep 2017 07:43:45 GMT

if all your CSV files have same number of columns with same name then you can try below

LOAD RECORD_NO,

COMPANY,

CUSTOMER_NO,

YEAR,

MONTH,

ITEM_NO,

QUANTITY,

EXTENDED_PRICE_AMT_LCL

FROM

[\\vmbis\HotFiles\SALES_INTERNATIONAL_*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Load several CSV Files where name begins with..

eduardo_dimperio — Tue, 12 Sep 2017 12:19:01 GMT

TMP:

LOAD

* // All fields

FROM

[\\vmbis\HotFiles\SALES_INTERNATIONAL_*.csv] //all csv with SALES_INTERNATIONAL_

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);