Hi Aneta
Without knowing more, it's difficult to know what the issue is. If you mean by "line by line" that you only want one line for a particular output, it typically you get more results than you expected because you are:
(1) not joining the tables completely, example: you may have joined on sales org but not distribution channel and division
(2) not using enough conditions to limit the output, example: it may not be valid for the time frame or perhaps was logically deleted, or you are including text but haven't specified a language.
If you can be more specific about what you're trying to extract and which tables you're using, we might be able to help you better.
Best Regards,
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------
Original Message:
Sent: 05-26-2020 03:22
From: Aneta Akelan
Subject: Query. Reading information from excel.
Dear All,
I am trying to create Query and had joint few tables. The Script works, but not in the desired that. The issue is, that when information is requested by excel, the Script is not reading line by line, but it is matching all entries with all entries. It means that if we are requesting for 15 items output, we are receiving 60 materials information.
Maybe it is easy way for the items to be read line by line?
Thank you.
BR,
Aneta
------------------------------
Aneta Akelan |
Metso Oy |
------------------------------