Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] why is tDenormalize not actually denormalizing?

I made a job in 3.0 that works fine (3rd and 4th pics). When I mimic'ed that job set up in 2.4.1 (1st and 2nd pics), the tDenormalize did not behave as expected.
in 3.0.0, this was the output of tDenormalize (which is what I want it to look like)


To see the whole post, download it here
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Jessica,
I'll try to guess. I actual use 2.4.x
Do you have only one column (named line) in your flow?
If so 2.4.x is working right because in the column list the "group by clause" is defined. If you only have one column, do not enter any value in this option box.
In 3.0.0 the box is named "To denormalize" so I would say there is a semantic change in the dialog. In 3.0.0 you have to define what to denormalize (in this case the rest is the group by clause).
Bye
Volker

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi Jessica,
I'll try to guess. I actual use 2.4.x
Do you have only one column (named line) in your flow?
If so 2.4.x is working right because in the column list the "group by clause" is defined. If you only have one column, do not enter any value in this option box.
In 3.0.0 the box is named "To denormalize" so I would say there is a semantic change in the dialog. In 3.0.0 you have to define what to denormalize (in this case the rest is the group by clause).
Bye
Volker
Anonymous
Not applicable
Author

ohok, that makes sense
thanks!