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
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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
751 Views
0 Likes
13 Replies
Anonymous
Not applicable
‎2012-01-11 03:01 AM
Author

Hi
Try to download tUnPivotRow at Exchange.
tUnPivot will change columns into rows.
Regards,
Pedro
568 Views
0 Likes
Anonymous
Not applicable
‎2012-01-11 07:13 AM
Author

Hi Pedro,
Thank you for your replay.
I wanna use it but I don't know how to using download components.
How can I use this component in Talend Job Designs?
Please help me!
568 Views
0 Likes
Anonymous
Not applicable
‎2012-01-11 07:39 AM
Author

Hi,
ou can unpack the component in a folder on your local system. After that, in Studio, you click Window -> Preferences, in the pref window you click Talend->Components.
There you specify the folder you unpacked the component in.
Now you should have the new component in your Pallet.
Hope this helps!
Regards,
Arno
568 Views
0 Likes
Anonymous
Not applicable
‎2012-01-13 04:22 AM
Author

Hi avdbrink,
Thank you for your help.
I have installed this component.
But, I don't know usage of this component in Talend job designer.
How should I do next when I exported main of row to join tUnPivotRow component?
What kind of value should be inserted of Input columns in this component?
Please help me!
Regards,
568 Views
0 Likes
Anonymous
Not applicable
‎2012-01-13 04:29 AM
Author

Hi
Here is the tested data.
00001;2,000;3,000;2,500
00002;2,200;3,000;1,000

Create job as the following images.
pivot_key and pivot_value must be defined in the schema.
Or you will get errors.
Best regards
Pedro
568 Views
0 Likes
Anonymous
Not applicable
‎2012-01-16 10:16 PM
Author

Hi pedro,
Thank you for your kindness!
I have tried procedure you teach but it's generated several errors.
Please check attached image with error message.
and does anyone know this cause or my mistake? ]
Regards,
568 Views
0 Likes
Anonymous
Not applicable
‎2012-01-16 10:29 PM
Author

Hi
Which version of TOS do you use?
First, change the type of pivot_value into Integer.
Then click "Code" tag and check the Java code of your job.
Or email me and attach your job.
Regards,
Pedro
568 Views
0 Likes
Anonymous
Not applicable
‎2012-01-17 12:42 AM
Author

Hi Pedro,
My TOS version is 4.2.3 for Win32.
This Job can't export due to error of compiling.
and I couldn't choose pivot_key and pivot_value in schema.
How should I do next?
Regards,
568 Views
0 Likes
Anonymous
Not applicable
‎2012-01-17 02:22 AM
Author

Hi
This must be a compatibility issue.
Because i can run this component correctly with JDK1.6.0_11(Win XPSP3).
But when it comes to JDK1.6.0_29(WIN7 32bit), it fails.
Now i try to test it in Linux.
I will update this component in my spare time.
Regards,
Pedro
568 Views
0 Likes