Discussion Board for collaboration on QlikView Scripting.
I have a text table that is in one Cell on a spreadsheet
In our database we have a table that I want to split this data out into new fields.
I have used the following expression in the load script Trim(SubField(mnoteshistory, '...')) as Last_Contact
The problem is that not all entries in the data is separated by a '...' how would I separate by '...' and 'none'
Thanks for any assistance
Thanks Joe for your help.
Both work well, I think I will use the substring map as not fully explored the data yet and will give me the flexibility I need.
View solution in original post
You can maybe do a replace on the none text and just use the single subfield then
hope that helps
another option that you have is to use a substring map, which might be better if you have more than just those two potential values for you subfield.
Mapping Load * Inline [
Use index function
if (index (field,'...')>0 ,subfield,field)
no worries glad to help