How to correctly import a job from talend link

[aaronrums]

I have downloaded the zip file from this link

Dynamic Schema Pivoting to Key-Value Pairs (talend.com)

However, when I try to import it into talend, I get this error (see attachment).

As you can see from the link, my ultimate goal is to be able to split records with many columns into key-value pairs.

For example, columns are FirstName, LastName and Age.

If there were 3 records initially, I would want to eventually produce 12 key value pairs, with the "key" being the column name and the "value" being the value.

I believe the job from that link would be really helpful, but I can't import it! Some help would be awesome, thank you.

[aaronrums]

correction : in the example I gave, I want to produce 9 key-value pairs. 3 records x 3 columns = 9 KV pairs. Sorry for the confusion.

[Anonymous]

Hi @Aaron Rumley​ 

You need a migration token to complete the importing, for more details, see this topic.  Here is a workaround for you to import the job.

1- Unzip the zip file, copy the three files of the component: *.item, *.properties and *.screenshot.

2- Open the Navigator viewer, expand the project_folder, right click on 'process' folder, then select 'paste' option to paste the three files.

3- Back to the Repository and fresh the job list.

I have imported successfully the job into studio 8.0.1 and run it.

Regards

Shong

[aaronrums]

awesome, thank you for that workaround! It works like a charm.

[aaronrums]

well...I spoke to soon. The only change I have to make is to change the main DBInput component to be a PostgresInput. After doing that, for some reason I was getting a NullPointer exception on the tmap_1. After solving that, I am getting an IndexOutOfBoundsException in the dynamicPivot javaFlex component. Did you encounter that? And do you know why it would cause any issues to switch the DB component to a postgres component? Thank you again

[Anonymous]

Hi

I think you can test any kind of database as long as it supports Dynamic schema.

Make sure you have changed the value to your real table name on tFixedFlowInput_1 component, and update the key_field value on tFixedFlowInput_2.

Regards

Shong

[aaronrums]

thank you Shong, I have posted this follow up question, if you could provide some assistance with that as well, that would be awesome!

Talend Community