Load only the first value found in excel sheet

Fri, 02 Jun 2017 18:04:41 GMT

Hello everyone, I am having an issue which I cannot solve.

I have several excel files, one for each month, where each line is a transaction. Sometimes the transactions in one file( from a certain month) are also in the next file ( for a following month). This means that in two different files the data for a certain transaction ID is duplicated. When I load this files into qlikview I want it to pull only unique transaction ids with its data. Right now, the transaction ID is unique but the fields for revenue show a value double ( or triple if the transaction happens to appear in three different files) and this is a big problems as I am seeing more revenue and more cost than there actually is.

Is there a way to make qlikview load only the value which appears first and ignore the data when that transaction ID appears again in another file?

Thank you

Re: Load only the first value found in excel sheet

m_woolf — Fri, 02 Jun 2017 18:21:37 GMT

Load

from ...

where not exists(ID);

topic Load only the first value found in excel sheet in QlikView

Load only the first value found in excel sheet

Re: Load only the first value found in excel sheet