topic Re: How to Split the data and display required value from the Column in Qlikview Script in QlikView

How to Split the data and display required value from the Column in Qlikview Script

shabarish0587 — Fri, 24 Sep 2021 08:58:09 GMT

Hi Folks,

I am facing one issue. i have a column like Tag. In this column i need to display middle value. i need to remove unwanted data. i tried using subfield. but i am not getting expected output. can anyone help me on this.

For eg: I have a value like this {NameImplement_ref/tag/123456} and i am expecting like this Implement. I need to remove {Name and also _ref/tag/123456} only between whatever i have the value i need to display . can anyone help me on this. i am sharing sample spreadsheet

Expected Output:

Re: How to Split the data and display required value from the Column in Qlikview Script

MayilVahanan — Fri, 24 Sep 2021 10:25:24 GMT

Try like below

Temp:
Load *, TextBetween(Tag, 'Name', '_ref') as ExpTag;
LOAD ID,
Project,
SubField(Tag, ',') as Tag
FROM
[D:\Qlik\Com\Tag_Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
OP:
Load ID, Project, Concat(Tag, ',') as Tag, Concat(ExpTag, ',') as ExpTag Resident Temp Group by ID, Project;

DROP Table Temp;

O/P:

Re: How to Split the data and display required value from the Column in Qlikview Script

shabarish0587 — Fri, 24 Sep 2021 16:57:27 GMT

Thank you Mayil Vahanan