HomeForum
Welcome, Guest

UNPIVOT Hangs processor
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: UNPIVOT Hangs processor

UNPIVOT Hangs processor 10 months ago #3355

  • oxalagu
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hi,
I try an unpivot with attached EXCEL asnd MAP; this makes aETL hang.
Thank you
Regards
Axel

Version: AETl Enterprise, version upgrade of today 4.2.6.5
Attachments:

Re: UNPIVOT Hangs processor 10 months ago #3356

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Reproduced the problem
Looking what can be done about it.

Peter

Re: UNPIVOT Hangs processor 10 months ago #3357

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Two problems here

Your target excel file has no extension
eg STD_V.95 but it should be STD_V.95.xlsx

second problem that you set transformation type to "add new/update existing records"

set it to add all records than it will work

(We will correct this inconvenience in the next release)

Please let us know the outcome

Mike

Re: UNPIVOT Hangs processor 10 months ago #3358

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Corrected in latest version

3.2.5.6

Improved support for spaces in table names and sql reserved words
Added clear log check box to transformation progress dialog
Added open open execution log button
Added Clone Row, Base64 Encode, Base64 Decode, GUID, Random transformation functions
Various bug fixes
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time. We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,
RBS 

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top