topic Re: Multiple CSV Files in QlikView in QlikView

Multiple CSV Files in QlikView

rmdnkevin — Mon, 02 Jul 2018 07:30:07 GMT

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 — Mon, 02 Jul 2018 15:56:12 GMT

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 — Tue, 03 Jul 2018 03:39:10 GMT

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 — Tue, 03 Jul 2018 11:55:46 GMT

You marked correct answer. That means solution with you.

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

rmdnkevin — Wed, 04 Jul 2018 00:57:03 GMT

Yeah, already solved.

Thank you so much for the responses