Search and Split a column

[aydiniletisim]

Hello,

I have a qvd file that has a column name REQUEST, in this column all the data combined. I want to seperate this data into seperate columns.

What i have in qvd;

What i want to see in data model viewer;

[vinieme12]

can you post some sample data in text or excel

[MartW]

Hi @aydiniletisim In qlik you can use the subfield function for this to split data.

[aydiniletisim · Accepted solution]

Hi,

A friend help me, this is what  we do in load editor;

LOAD
REQUEST,
REPLACE(TextBetween((REPLACE(REQUEST,',"','}"')),'"IdentityNumber":','}'),'"','') as IdentityNumber,
REPLACE(TextBetween((REPLACE(REQUEST,',"','}"')),'"ReferenceNumber":','}'),'"','') as ReferenceNumber,
REPLACE(TextBetween((REPLACE(REQUEST,',"','}"')),'"TransactionType":','}'),'"','') as TransactionType,
REPLACE(TextBetween((REPLACE(REQUEST,',"','}"')),'"Amount":','}'),'"','') as Amount,
REPLACE(TextBetween((REPLACE(REQUEST,',"','}"')),'"AlwaysSendOTP":','}'),'"','') as AlwaysSendOTP
FROM [lib://CONNECTION_AUDIT.qvd]
(qvd);