Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Any way of doing text analysis on the unstructured text in Qlikview?
Maybe the correlation of certain words for example.
please share this excel file -
And you may forget fact table semi colon by end. That means before Mapping table. Please add and then tell us the error
Hi Anil
attached sample xls file.
Check now with your file. And change accordingly your path
Hi Anil,
Thanks but actually i trying to implement the 2nd example from Macro.
Try same with v2 and use your excel instead of qvd under script which Macro provided.
did you try like this?
mapCharToSpace:
Mapping LOAD char, ' ' Inline "
char
,
.
(
)
:
;
/
[
]
" (delimiter is spaces);
WO_with_Job_codes_table:
LOAD AutoNumber([WO Description]) as ID,
[WO No],
[Cntr ID],
[Cntr No],
[WO Created],
[WO Description],
Year([WO Created]) as Year,
Day([WO Created]) as Day,
Month([WO Created]) as Month
FROM [https://community.qlik.com/servlet/JiveServlet/download/1246079-273313/sample.xlsx] (ooxml, embedded labels, table is WO_with_Job_codes_table);
tabWord:
LOAD ID,
Word
Where FindOneOf(Left(Word,1),'ABCDEFGHIJKLMNOPQRSTUVWXYZ');
LOAD ID,
SubField(MapSubString('mapCharToSpace',[WO Description]),' ') as Word
Resident WO_with_Job_codes_table;
tabWord2:
LOAD ID,
Word as Word2
Resident tabWord;
regards
Marco
please close your thread if your question is answered:
Qlik Community Tip: Marking Replies as Correct or Helpful
thanks
regards
Marco