Hi,
Here is my Data in 2 logs having 3 fields:
Log1:
Books Bought AccountName={} , BookIds={}
(here BookId can contains multiple bookIds)
eg:
Books Bought AccountName={ABC} , BookIds={book1, book2, book3}
Books Bought AccountName={ABC} , BookIds={book1}
Books Bought AccountName={DEF} , BookIds={book1, book2}
Books Bought AccountName={EPF} , BookIds={book1, book3}
Books Bought AccountName={EPF} , BookIds={book1}
Log2:
Books Sold AccountName={} , BookId={}
(here BookId contains only one bookId)
Eg.
Books Sold AccountName={ABC} , BookId={book2}
Books Sold AccountName={EPF} , BookId={book1}
Books Sold AccountName={EPF} , BookId={book1}
Result I want:
AccountName
Total Books
bookName
bought
sold
ABC
4
book1 book2 book3
2 1 1
0 1 0
DEF
2
book1 book2
1 1
0 0
EPF
3
book1 book3
2 1
2 0
can anyone please help me. Tried but not getting the result.
... View more