Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
rmdnkevin
New Contributor III

Multiple CSV Files in QlikView

Hello, I'm a beginner in QlikView.

I need to input multiple files in Qlik, the example name of the file is KP2018XX (XX as the month).

Here as the overview of the file.

File NameEmailNameStatus
KP201801xxxxxxxxx
KP201802xxxxxxxxx
KP201803xxxxxxxxx


How do I transform those table into a table like this ?


MonthYearEmailNameStatus
Jan2018xxxxxxxxx
Feb2018xxxxxxxxx
Mar2018xxxxxxxxx

Any help would be greatly appreciated.

Thanks

1 Solution

Accepted Solutions

Re: Multiple CSV Files in QlikView

I didn't see any challenges here. Might you can think like this?

Load Month(Num#(Right([File Name],2))) as Month,

         Year(Left(Right([File Name],6),4)) as Year,

         Email,

         Name,

         Status

From Table;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
4 Replies

Re: Multiple CSV Files in QlikView

I didn't see any challenges here. Might you can think like this?

Load Month(Num#(Right([File Name],2))) as Month,

         Year(Left(Right([File Name],6),4)) as Year,

         Email,

         Name,

         Status

From Table;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rmdnkevin
New Contributor III

Re: Multiple CSV Files in QlikView

What should the [File Name] be filled in ?

I'm currently using example (201807) as the File Name, but it shows like that. PT1.png

Re: Multiple CSV Files in QlikView

You marked correct answer. That means solution with you.

But, to your question there might be date format issue with filenames.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rmdnkevin
New Contributor III

Re: Multiple CSV Files in QlikView

Yeah, already solved.

Thank you so much for the responses