Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rmdnkevin
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
Anil_Babu_Samineni

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;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Anil_Babu_Samineni

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;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Contributor III
Contributor III
Author

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

Anil_Babu_Samineni

You marked correct answer. That means solution with you.

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Contributor III
Contributor III
Author

Yeah, already solved.

Thank you so much for the responses