Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would be gratefull if you could hepl me with my task in Qlik Sense.
I have table words_frequency_1.Word which contains some similar words or symbols.
I need to write all similar words in another table only once.
Then I need to count how many times was every Word from table repeated in table.
I dont have big experience with script writing in Qlik Sense so I am asking for help.
Thanks in advance:)
Hello.
I hope to be helping.
[mapCharacter]:
Mapping Load * Inline [
from, to
'/',' '
'_',' '
];
Data:
Load * Inline [
"TextLine"
"Hi, I would be gratefull if you could hepl me with my task in Qlik Sense. I have table words_frequency_1.Word which contains some similar words or symbols. I need to write all similar words in another table only once. Then I need to count how many times was every Word from table repeated in table."
];
MyTextData:
LOAD
RowNo() as ID,
PurgeChar(MapSubString('mapCharacter' ,TextLine),'.?!$:;<–>[],()#"-1234567890') as TextLine
Resident Data;
Drop Table Data;
MyWordList:
LOAD
ID,
RowNo() as IDWord,
lower(SubField(TextLine,' ')) as Word
Resident MyTextData;
frequency_word:
LOAD
Word,
Count(IDWord) as frequency
Resident MyWordList
Where Word<>'' or not IsNull(Word)
Group By Word;