Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
I have requirement in which I need count of items and sum of items in the bottom row as mentioned in the image in a straight or pivot table.
But in Single object not in multiple objects.
Please suggest me.
Hey jagan - One quick question. I know why you added ADD (because you might have done a partial reload). What is ONLY used for here (Never used it or seen it getting used)
Thanks,
Sunny
If it is not possible in direct method, we need to go in indirect method like this by changing script and changing expressions Sunny!!!!!
Regards,
Jagan.
Only ADD:
Tab1:
LOAD Name, Number FROM Persons.csv;
ADD LOAD Name, Number FROM newPersons.csv;
During normal reload, data is loaded from Persons.csv and stored in the
QlikView table Tab1. Data from NewPersons.csv is then concatenated to the
same QlikView table.
During partial reload, data is loaded from NewPersons.csv and appended to
the QlikView table Tab1. No check for duplicates is made.
Tab1:
LOAD Name, Number FROM Persons.csv;
ADD ONLY LOAD Name, Number FROM NewPersons.csv Where not exists(Name);
During normal reload, data is loaded from Persons.csv and stored in the
QlikView table Tab1. The statement loading NewPersons.csv is disregarded.
During partial reload, data is loaded from NewPersons.csv which is appended
to the QlikView table Tab1. A check for duplicates is made by means of
seeing if Name exists in the previously loaded table data.
Hope this helps you.
Regards,
Jagan.
100% Agreed and I always vouch for script changes rather than putting a lot of my time on the front end.
I was under the impression that ADD and REPLACE only work with Partial Reload, i.e., the table with ADD and REPLACE keywords are disregarded. I guess I need to check the partial reload basics.
Thanks for the clarification jagan