Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted

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)

View solution in original post

4 Replies
Highlighted

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)

View solution in original post

Highlighted
Contributor III
Contributor III

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

Highlighted

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)
Highlighted
Contributor III
Contributor III

Yeah, already solved.

Thank you so much for the responses