Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Hi
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:
Hi
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:
Thank you Mayil Vahanan