This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I create calculate dim that extract the data from the word 'Language' till the comma after it.
The calculate : subfield(subfield(EMAIL_SUBJECT,'Language ',2),',',1)
For both rows I received the word "English".
The problem is that I received the result only when I calculate this in expression but when I moved the calculate to the script I didn't received results:
Load subfield(subfield(EMAIL_SUBJECT,'Language ',2),',',1) AS EMAIL_LANGUAGE
Could you please advise?
It seems a problem with commas in your data.
For an Inline table, you can quote your data and then split with subfield.
LOAD DATA, subfield(subfield(DATA,'Language ',2),',',1) as DATA_CLEANSED INLINE [DATA"asddsfdsf,Email Language English,try1,try2,Email""Email Language English,sfsdfds,g,gh"];
For other data sources, it depends on the source; but as I mentioned it seems to relate with commas in your data.
View solution in original post
I can confirm you that this is not an issue with subfield(). The issue would be with your script, it could be wrong field reference, ....just try to investigate and you would get it.