How to convert text file into tabuler format in qliksense

[Rsaiq]

Hi All,

I need to convert a table data of a text file into tabuler format in qliksense.

Below is my source data which is in a text file:-

----------NEW TRANSACTON-----------
TRANSACTION DATE : 09:42 AM, 04 Dec 2021
CLIENT ID : 11
CLIENT NAME : A
AMOUNT : 100
TRANSACTION REF. : 1

----------NEW TRANSACTON-----------
TRANSACTION DATE : 09:54 AM, 04 Dec 2021
CLIENT ID : 12
CLIENT NAME : B
AMOUNT : 200
TRANSACTION REF. : 2

----------NEW TRANSACTON-----------
TRANSACTION DATE : 09:58 AM, 04 Dec 2021
CLIENT ID : 13
CLIENT NAME : C
AMOUNT : 300
TRANSACTION REF. : 3

----------NEW TRANSACTON-----------
TRANSACTION DATE : 10:40 AM, 04 Dec 2021
CLIENT ID : 14
CLIENT NAME : D
AMOUNT : 400
TRANSACTION REF. : 4

Now I need this data in qliksense as below

Can anyone please help me to resolve this issue.

Kindly find source file(txt file) in the attachment.

Thanks in advance

[Akshesh_Patel]

Hi,

This might help : https://community.qlik.com/t5/QlikView-App-Dev/Convert-Plain-Text-File-to-Table/m-p/838478

The above link is for QlikView but follows the same logic in qlik sense as well.

Thank you