Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Transform Pitvot table

Transform Pitvot table 7 years 9 months ago #4429

  • Barton
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0
Hello

I am loading data from the pivot table and would like to load block number within the pivot into separate field.

My source is an Excel file 2010 and target is oracle.

How can I do that?

Bart

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

Re: Transform Pitvot table 7 years 9 months ago #4430

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7638
  • Karma: 33
  • Thank you received: 425
This is simple

Set mapping type to calculated and use this as as calculation

GetSystemVariable('BLOCKNUMBER')

See attached picture,
Mike
Mike
Attachments:

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

  • Page:
  • 1

We have 308 guests and 2 members online