idea Re: Option Load DISTINCT from Data Manager - Status changed to: Closed - Archived in Suggest an Idea

Option Load DISTINCT from Data Manager

MaxCh — Wed, 15 Feb 2023 14:42:36 GMT

•User case: If there are duplicate records in the raw data, only one of them will be loaded with data manager.

•Proposed solution: Provide a switch/option to turn this function on and off to LOAD DISTINCT from data manager

Re: Ignored duplicated records

Meghann_MacDonald — Tue, 14 Feb 2023 13:30:11 GMT

Hi @MaxCh , this can be done already by adding the word "Distinct" after LOAD in the script, which will only load rows 1 unique time. Is this what you are looking for?

Meghann

Re: Ignored duplicated records

MaxCh — Wed, 15 Feb 2023 07:32:24 GMT

Hi @Meghann_MacDonald,

Thank you for your reply and I will let my teammates know this method.

Would it be possible to have such a function in data load manager as well? Most of our clients are not using the script editor to load data for not having much technical knowledge, and we want to make it easier for them.

Many thanks,
Max

Re: Option Load DISTINCT from Data Manager

Meghann_MacDonald — Wed, 15 Feb 2023 14:43:53 GMT

Hi @MaxCh , sure, I think that's a great idea and reflects Qlik's goals. I adjusted the text of your post slightly to provide clarity - hope that's ok. Will have this pushed into the review process.

Meghann

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:36:27 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Option Load DISTINCT from Data Manager - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:36:29 GMT