This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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,
View solution in original post
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