Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

normalize or not?

Hi!

I have a excel file with a lot of sales data. Each row contains information of customer, date, referens and so on.

My question is if I should divide the table into several tables through the script so that I get a customer table, an order table, un order row table.

If I do it in SQL I would and then use JOIN

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The quick answer is no. In general, QV works best with denormalized data. There are exceptions of course. But the typical reasons for normalization -- space savings, referential integrity, etc -- don't usually apply to QV. So leave it denormalized as is.

-Rob

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The quick answer is no. In general, QV works best with denormalized data. There are exceptions of course. But the typical reasons for normalization -- space savings, referential integrity, etc -- don't usually apply to QV. So leave it denormalized as is.

-Rob