Suggest an Idea

[MaxCh]

•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

[Meghann_MacDonald]

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

[MaxCh]

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

[Meghann_MacDonald]

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

[Meghann_MacDonald]

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.