Hi Experts,
Quick question, I normally received data on my email everyday and is on this format like below:
Account number: 122225
Date: 09/01/2018
Method of transaction: XXX Credit
Amount : 233610,97
Account number: 554555
Date: 02/11/2017
Method of transaction: XXX Credit
Amount: 155403,09
Account number: 678919
Date: 16/10/2017
Method of transaction: XXX Credit
Amount: 151698,36
Expected output on my Qlikview application is
| Account number | Date | Method of transaction | Amount |
| 122225 | 09/01/2018 | XXX Credit | 33610,97 |
| 554555 | 02/11/2017 | XXX Credit | 155403,09 |
| 678919 | 16/10/2017 | XXX Credit | 151698,36 |
Your assistance will be highly appreciated
