Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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;

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;

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

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.

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