Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2012-01-11 01:29 AM

How to create two or more sequences from a row in Excel file

Hello,
Everyone please teach me!
What I wanna do is like a following.
The following data exists in Excel I wanna transfer(INPUT).
CUL_CD || 2012_02 || 2012_03 || 2012_04 || ???|| 2013_01 ||
00001 2,000 3,000 2,500 3,000
00002 2,000 2,500 1,000 2,000

The following data are what I wanna create(OUTPUT).
CUL_CD || MONTH || AMOUNT
00001 2012_02 2,000
00001 2012_03 3,000
? ? ?
? ? ?
? ? ?
00002 2012_02 2,000
How can I create this data?
Could you teach me some components that can create?
Thanks!
Labels (2)
Labels
763 Views
0 Likes
13 Replies
Anonymous
Not applicable
‎2012-01-17 03:47 AM
Author

Hi,
Thank you for your response.
Is this problem about version of JDK?
Incidentally, my environment is for XP.
Regards,
184 Views
0 Likes
Anonymous
Not applicable
‎2012-01-17 03:50 AM
Author

Hi
I feel confused this time. Because i change the JDK and JRE version into 1.6.0_11.
But these errors still occur.
Best regards,
Pedro
184 Views
0 Likes
Anonymous
Not applicable
‎2012-01-17 06:08 AM
Author

Hi
In a word,
It couldn't run on Windows?
Regards,
184 Views
0 Likes
Anonymous
Not applicable
‎2013-02-07 12:31 PM
Author

Hi
I am having issues with tUnPivotRow component.
Its not showing up in my pallet. I am using TOS 5.2.1
Can any one suggest me a solution.
Thanks
RS
184 Views
0 Likes