writer is not working for data transformation

  • Posts: 76
  • Thank you received: 2

Multiply column numbers with -1 was created by ankita

Hi,

i have one column, name ' Cost' contains all numeric values, I want to make them negative.
I tried to multiply with -1, using literals and multiply functions, But it is not working
Please find the below attachment of mapping
1 month 1 week ago #20186
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 1078
  • Karma: 3
  • Thank you received: 127

Replied by Peter.Jonson on topic Multiply column numbers with -1

Unfortunately, I cannot see your data so I will try to guess.

In order to make it work you have to get rid of special characters.

eg convert $100,111.12 to 100111.12.

You can use Delete Characters transformation functions for that

www.etl-tools.com/wiki/aetle/transformat...gs/delete_characters
Peter Jonson
Support Analist
The following user(s) said Thank You: ankita
1 month 1 week ago #20187

Please Log in or Create an account to join the conversation.

  • Posts: 76
  • Thank you received: 2

Replied by ankita on topic writer is not working for data transformation

I implemented the mapping, which includes 4 readers and 2 writers.
When i tried to run for both writers only second writer is filled properly, for first writer it is not performing the data transformation.
could you guide me, why this is happening
1 month 1 week ago #20188
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 1078
  • Karma: 3
  • Thank you received: 127

Replied by Peter.Jonson on topic writer is not working for data transformation

Are you writing data into different files or file name is the same?
Peter Jonson
Support Analist
1 month 1 week ago #20189

Please Log in or Create an account to join the conversation.

  • Posts: 76
  • Thank you received: 2

Replied by ankita on topic writer is not working for data transformation

File name is same but sheet names are different
I have one excel file, which has 8 sheets, Now I tried writing on 2 sheets
1 month 1 week ago #20190

Please Log in or Create an account to join the conversation.

  • Posts: 76
  • Thank you received: 2

Replied by ankita on topic writer is not working for data transformation

Please update, if you need more information
1 month 1 week ago #20191

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies