Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have installed tUnpivotrow for 7.01. but its not showing in palette panel. Here is my xml for this.
<COMPONENT>
<HEADER
PLATEFORM="ALL"
SERIAL=""
VERSION="1"
STATUS="FINAL"
COMPATIBILITY="ALL"
AUTHOR="Talend"
RELEASE_DATE="20090318"
STARTABLE="false"
DATA_AUTO_PROPAGATE="false"
SCHEMA_AUTO_PROPAGATE="false"
VISIBLE="true"
IS_MULTIPLYING_OUTPUTS="true"
>
<SIGNATURE></SIGNATURE>
</HEADER>
<DOCUMENTATION>
<URL />
</DOCUMENTATION>
<CONNECTORS>
<CONNECTOR CTYPE="FLOW" MAX_INPUT="1" MAX_OUTPUT="1"/>
<CONNECTOR CTYPE="ITERATE" MAX_OUTPUT="0" MAX_INPUT="0" />
<CONNECTOR CTYPE="SUBJOB_OK" MAX_INPUT="1" />
<CONNECTOR CTYPE="SUBJOB_ERROR" MAX_INPUT="1" />
<CONNECTOR CTYPE="COMPONENT_OK" />
<CONNECTOR CTYPE="COMPONENT_ERROR" />
<CONNECTOR CTYPE="RUN_IF" />
</CONNECTORS>
<PARAMETERS>
<PARAMETER
NAME="WARNING"
FIELD="LABEL"
REQUIRED="true"
NUM_ROW="10"
CONTEXT="0;255;0"
>
<DEFAULT>Columns outside the row keys will be unpivoted</DEFAULT>
</PARAMETER>
<PARAMETER
NAME="SCHEMA"
FIELD="SCHEMA_TYPE"
REQUIRED="true"
NUM_ROW="20"
READONLY="false"
>
<TABLE READONLY="false">
<COLUMN NAME="pivot_key" TYPE="id_String" READONLY="true"/>
<COLUMN NAME="pivot_value" TYPE="id_String" READONLY="true"/>
</TABLE>
</PARAMETER>
<PARAMETER
NAME="ROW_KEYS"
FIELD="TABLE"
NUM_ROW="30"
NB_LINES="4"
>
<ITEMS>
<ITEM NAME="COLUMN" FIELD="PREV_COLUMN_LIST" />
</ITEMS>
</PARAMETER>
</PARAMETERS>
<CODEGENERATION/>
<RETURNS>
</RETURNS>
</COMPONENT>
Hello,
Sorry for delay!
I made a testing about this issue and it displays well from my side in V 7.0.1.
Please have a look at my screenshot
Best regards
Sabrina
Hello,
If the component does not appear in the Palette, there are several possible causes:
For more information, please have a look at this document:TalendHelpCenter:Installing a custom component
Additionally, talend 7.0.1 is not list on the Compatibility table from this page:
Are you able to use this custom component on other supported platforms?
Best regards
Sabrina
Hi,
I tried on different systems for talend 7.0.1 version. still I am not able to see that custom component in palette. I tried many times.
Hello,
We will try to install this custom component later on V 7.0.1 to see if it could be shown in palette panel.
Could you please elaborate your case with an example with input and expected output values? We would like to see if there will be any alternative solution.
Best regards
Sabrina
Hi,
My requirement is to convert the columns into Rows (de-normalize the data). so I thought tUnpivotrow is the component to do this.
Hi,
Do you have any further update on this.
Hello,
Sorry for delay!
I made a testing about this issue and it displays well from my side in V 7.0.1.
Please have a look at my screenshot
Best regards
Sabrina