How to copy the value in column to all the rows

  • Posts: 22
  • Thank you received: 0

How to copy the value in column to all the rows was created by vattikonda

Hi Sir,

I want to copy the value in a column to all the other rows. How can I do that ?

Example : As you see in the attached screen shot, I want to copy the currency to all other empty values in the same column

Thanks and Regards,
Prasanth Vattikonda
1 week 1 day ago #20530
Attachments:

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

  • Posts: 8015
  • Karma: 33
  • Thank you received: 502

Replied by admin on topic How to copy the value in column to all the rows

Please Keep Value transformation function

www.etl-tools.com/wiki/aetle/transformat...ellaneous/keep_value
Mike
1 week 1 day ago #20532

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

  • Posts: 22
  • Thank you received: 0

Replied by vattikonda on topic How to copy the value in column to all the rows

Sir,

But keep value will only copy the value to rows next to it. But , it doesn't copy the rows before to it.

Thanks
1 week 12 hours ago #20542

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

  • Posts: 8015
  • Karma: 33
  • Thank you received: 502

Replied by admin on topic How to copy the value in column to all the rows

Just sort the data than your value will become first and keep the value will copy the data to all rows
Mike
1 week 11 hours ago #20543

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