Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
New to Qlikview. I was given a query for taking Excel data and separating out numbers from within the values (e.g., 5G;#1, CAPLAIN;#2, etc.):
table1:
load * from table1;
RecordTagsFromTable1:
load KeyWords, subfield(purgechar(KeyWords, '#'), ';') as RecordTag resident table1;
The results produced a list box that separated word values from the number values:
List Box:
5G
CAPLAN
AMI
1
2
3
Is there a way to remove the numbers and just keep the text values?
table1:
load * from table1;
RecordTagsFromTable1:
load KeyWords, subfield(KeyWords, ';' , 1) as RecordTag resident table1;
what exactly does the data look like!!