Discussion Board for collaboration on QlikView Scripting.
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.
How do I transform those table into a table like this ?
Any help would be greatly appreciated.
Go to 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,
What should the [File Name] be filled in ?
I'm currently using example (201807) as the File Name, but it shows like that.
You marked correct answer. That means solution with you.
But, to your question there might be date format issue with filenames.
Yeah, already solved.
Thank you so much for the responses