Question

Excel Question

0

HelloThere are three excel tables, each of which stores different data, but is related by identification number. I want to take the data specified in three tables according to the identification number into another new EXCEL table. How can I write all the required data into it. My table 2 has more data than table 1, but they have the same pbnumber and date

asked 2020-08-13

TanXS

1 answers

Tim v Steenbergen · Answer 1 · 2020-08-13

Since you’re asking this on a Mendix forum, I assume you are looking for a Mendix answer. Here we go:

- use Excel importer from the AppStore

- import each Excel table separately and import them to the same table using Date and PBNumber as key (not sure if you can use two keyfields, if not, then first in Excel concatenate the values of Date and PBNumber in a new column, say DatePBNumber)

- show the result on a page and add the standard ‘Export to CSV’ function

NB. If you were to ask this on a Excel forum, I would advise you to get creative with VLOOKUP-function, and at the same time warning you about performance problems when a lot of cells have a VLOOKUP-function.