Multiple CSV Files in QlikView

[rmdnkevin]

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 Name	Email	Name	Status
KP201801	xxx	xxx	xxx
KP201802	xxx	xxx	xxx
KP201803	xxx	xxx	xxx

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

Month	Year	Email	Name	Status
Jan	2018	xxx	xxx	xxx
Feb	2018	xxx	xxx	xxx
Mar	2018	xxx	xxx	xxx

Any help would be greatly appreciated.

Thanks

[Anil_Babu_Samineni · Accepted solution]

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;

[rmdnkevin]

What should the [File Name] be filled in ?

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

[Anil_Babu_Samineni]

You marked correct answer. That means solution with you.

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

[rmdnkevin]

Yeah, already solved.

Thank you so much for the responses