You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-04-01 19:26:44

bstamper1
Member
4 posts

bstamper1 said:

.csv Data Transformation

I have a .csv document that I need to make some transformations to before upserting into Salesforce.
Here is how the document appears as is.

mini_skillscsv.png 

The first row of the document represents Skill Names (MECH TECH (TM2500), MECH TA LM 2500, etc…).

The third row represents Skill Categories (TM, MECH TA).  MECH TA applies to both skills MECH TA LM 2500 and MECH TA LM6000 even though it is not filled in.

The SSO represents a unique ID for the People under Rep Name.

The number represents and expertise level (1, 2, 3). So an SSO has a an expertise (level 1, 2 or 3) in a specific Skill (MECH TA LM 2500)

I would like to use Talend to perform a transformation to generate two different sets of data.

The first being skills with columns for Skill Name and Skill Category:


mini_skillscsv1.png
The second being expertise with Columns for SSO, Skill Name, and Skill Level:

mini_skillscsv2.png

I am able to use the tSplitRow component to separate out the Skill Names, but cannot figure out how to do the rest of the transformation.  Can anyone help solve this problem using Talend?

Last edited by bstamper1 (2016-04-06 14:38:32)

Offline

#2 2016-04-05 09:51:38

xdshi
Talend Team


xdshi said:

Re: .csv Data Transformation

Hi,
We cannot see the image you provided. Could you please upload your screenshots into forum?
Elaborating your case with an example with input and expected output values will be preferred.
Best regards
Sabrina
mini_pastedImage.png_20160405-0151.png


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-04-06 14:39:08

bstamper1
Member
4 posts

bstamper1 said:

Re: .csv Data Transformation

Can you see the images now?
I uploaded them and dragged into the post. 

Offline

#4 2016-04-11 09:19:21

xdshi
Talend Team


xdshi said:

Re: .csv Data Transformation

Hi,
We have seen your screenshots. Thanks for posting them again.
We are working on your use case then come back to you as soon as we can.
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy