unstructured text analysis

[#1]

Hi there,

Any way of doing text analysis on the unstructured text  in Qlikview?

Maybe the correlation of certain words for example.

[Anil_Babu_Samineni]

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

[#3]

Hi Anil

attached sample xls file.

[Anil_Babu_Samineni]

Check now with your file. And change accordingly your path

[#5]

Hi Anil,

Thanks but actually i trying to implement the 2nd example from Macro.

https://community.qlik.com/message/1245108#1245108

[Anil_Babu_Samineni]

Try same with v2 and use your excel instead of qvd under script which Macro provided.

[MarcoWedel]

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

[MarcoWedel]

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco