Stock control with excel data

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I'm new to Qlik and just starting to learn how to work with it. I have been reading thru a lot of posts regarding auto-incremental excels, comparing excels and some more stuff but i still have not found any hints that could help me on my project.

I'm trying to load one starting excel into Qlik, it has a table with 4 columns, like in the following pic

Then i need to load a second excel, with the same structure, but the data can be different in the column of total units or have one entire new line.

What i need to do with this two excel files is:

- Generate one table (lets call it table C) with the columns B,C and D of the first file.

- Generate one new column in Table C with the data of the column D of the second excel file.

- If in the second excel file are any new "unique numbers" not present in the first excel file add them.

The final result should be something like the next pic:

Once i have the first "Table C" i will need to update it periodically with a new excel, the mechanics of the update are:

- Check in the new excel for any new "unique number" and add it.

- Take the data from the previous Column D and move it to Column C (the data of column C is deleted).

- Take the data of the new excel and paste it into Column D.

I know its a lot of stuff to do, i'm already working in it so any document, reference, bit of code or suggestion will be greatly appreciated.

In the end what i need is something to control the stock of some products, if anyone has a better suggestion on how to do this so i can take advantage of the Qlik functionalities i will really appreciate it.

Thanks for your time.

Oscar.

P.D: I'm using the last version of Qlik Sense Desktop.

topic Stock control with excel data in QlikView

Stock control with excel data