Still need help with pivots - Single Column Pivot

Do you know there is an upper limit to characters in Pivot Key for some reason ? Please remove , makes user job difficult  . See video at 4:24 to know what I am talking about

We will check it.

Can we publish the video you created on our youtube channel?

Peter.Jonson wrote:

Do you know there is an upper limit to characters in Pivot Key for some reason ? Please remove , makes user job difficult  . See video at 4:24 to know what I am talking about

We will check it.

Can we publish the video you created on our youtube channel?

Yeah of course , please publish . I suggest also putting the input/output and transformation file you created to go with as well, so someone can demo ETL and try this as well . 

Also the video has some rough cuts inside it , it took me 6 minutes to get output file sorted

Thank you, I really like your video.

You can see it here.


We also fixed the issue with field length limit. It was 20 which is obviously not sufficient. We set to 1024

admin wrote:

Thank you, I really like your video.

You can see it here.

We also fixed the issue with field length limit. It was 20 which is obviously not sufficient. We set to 1024

WOHOO !! Thanks for the bug fix and glad you like it , and it can be of help