Hi @ishans52004352
Sorry for the confusion. Here is the details of the issue am facing.
Key | Product | Product Code |
123 | Books | 10 |
123 | Pen | 15 |
123 | Bag | 20 |
Please consider the above table. The “last value“ is the last record mentioned for the "Product": "Bag" and "Product Code":"20", this was the only record available in AA and the other two records was not imported into AA. So if we are reporting by "Product" only the “Bag“ product and product code "20" is available for key “123”. There is no record for first 2 line items in the above table i.e. "Product" and "Product Code" that this "Key" is also part of "Books" and "Pen" product and "10" and "15" product code respectively.
I would like to see all the records in the table in AA, even though it have same key value.
Is there any way to achieve this.
Appreciate your help!
Thanks!