Hi.
I have a problem! In Visual Studio I am working with a table with the original data. Unfortunately, the table consists of master data and each row also contains data for 6 articles and some details. Below pls. find and example just with 2 articles.
| Company | Date | Customer | Article1 | Article2 | Deviation1 | Deviation2 |
| 1070 | 03.05.2019 | 2180216 | 17087246.215 | 17046284.213 | Wrong qty | Broken items |
| 1070 | 02.05.2019 | 2180217 | 17046284.213 | 17087246.215 | Wrong qty | Broken items |
I have created new tables, each containing the master data (company, date etc.) and the details for each article, so the first new table contains master data and data related to article 1 - with one row per article. These new tables I merge with "Union" in a new total table. For above example the new table now consists of 4 rows. 2 rows with article 1 and 2 rows with article 2.
My problem is that the tables I merge have different columns orders, which means the new total table looks odd. For example Table 1 starts with "Company" and Table2 starts with "Date".
This is the formula I am using for article 2:
=FILTER(SUMMARIZE(WarehouseDev;WarehouseDev[Business unit Id];WarehouseDev[Case status];WarehouseDev[Case status ID];WarehouseDev[Caseid];WarehouseDev[ConfDate];WarehouseDev[Costs, other];WarehouseDev[CostsRoth];WarehouseDev[CostsTransp];WarehouseDev[Country];WarehouseDev[Created];WarehouseDev[Created by];WarehouseDev[Created by id];WarehouseDev[CustomerNo];WarehouseDev[DateClosed];WarehouseDev[DeliveryNo];WarehouseDev[Description];WarehouseDev[DevApprov];WarehouseDev[DevHeadline];WarehouseDev[DeviationWH2];WarehouseDev[Discarding code];WarehouseDev[Documents];WarehouseDev[Encryption contract];WarehouseDev[EntireOrder];WarehouseDev[ExtCustOrderNo];WarehouseDev[Idea from];WarehouseDev[Identity contactId];WarehouseDev[Identity type];WarehouseDev[Identity value];WarehouseDev[InstructHeadline];WarehouseDev[InstructionDevWH2];WarehouseDev[Last edited];WarehouseDev[Last edited by];WarehouseDev[Last edited by id];WarehouseDev[Node Type];WarehouseDev[Number];WarehouseDev[Path];WarehouseDev[Picker];WarehouseDev[Pos2];WarehouseDev[Project deadline];WarehouseDev[Project Follow-Up];WarehouseDev[Project name];WarehouseDev[QtyDel2];WarehouseDev[QtyOrder2];WarehouseDev[Resp. for Follow-Up];WarehouseDev[SAPArticle2];WarehouseDev[SAPCustOrderNo];WarehouseDev[Title];WarehouseDev[WHDevClosed];WarehouseDev[WHDevCreated];WarehouseDev[WHDevFinalComments];WarehouseDev[WHDevFollowUp];WarehouseDev[WHDevRNEFinished];WarehouseDev[WHDevSalesFinished]);WarehouseDev[SAPArticle2]<>BLANK())
How can this be? What am I doing wrong?
Thanks a lot in advance.
Br. Helen
