topic Re: Create Fields from File Name in QlikView

Create Fields from File Name

rmdnkevin — Tue, 03 Jul 2018 06:27:57 GMT

Hi.

I have a problem to create some fields such as year and month from file name.

I'm using 201801 for the file name, 2018 indicates the year and 01 means the month.

Can anyone help me how to do this ?

Thanks a lot

- Kevin -

ujjwalraja — Tue, 03 Jul 2018 06:38:52 GMT

Hi Kevin,

You can use the left and right function to achieve this.

For Example-

Left(201801,4) will give you 2018 i.e the Year

Right(201801,2) will give you 01 i.e the Month.

Note- To get filename in the script you can use the FileBaseName() function.

Let me know if it fulfils your requirement.

MindaugasBacius — Tue, 03 Jul 2018 06:42:22 GMT

Use the FileBaseName() function:

Load *

,Right(FileBaseName(), 4) as Year

,Left(FileBaseName(),2) as Month

From

xslx

;

rmdnkevin — Tue, 03 Jul 2018 07:00:28 GMT

Thanks a lot for the answer