Discussion board where members can get started with QlikView.
I have a situation like this:
INLINE LOAD * [
I would like to have the field value for ABC like this:
Is there a way to reach to the field value like this?
Thanks & Regards
Go to Solution.
May be this
Capitalize(SubField(ABC, '_', -2) & ' ' & SubField(ABC, '_', -1)) as NewABC
purgechar(Right(ABC, len( ABC ) -Index(ABC,'_', -2)),'_') as LastSecond1;
load * inline [
Your solution looks very good. But if the Value is not just two words i.e kind of variable in nature in that case what would be the solution?
Like Sports Too
The number of words in the field value Varies here.
There needs to be some way for us to let QlikView know how many words from the end do we need.... right? What is that logic for you?
Thanks for your reply again.
Lets say we have these three values for this particular field and requirements for the three different values are different.
MY_NAME_IS_XYZ -------------------> we need to extract only the last word
I_LIKE_READING_BOOKS_VERY_MUCH -------- we need to extract only the last two words
ALTHOUGH_I_LIKE_SPORTS_TOO -----------> we need to extract last three words
Apologies if i creates confusion!
Thanks & regards,
These are the only three possible values that you field can ever have? I am just trying to understand because if the above is true, then you can do this so easily using Mapping Load or If Statement of Pick Match...
how do you identify which line needs 1 piece and which line needs 3
No There are Many values but i just provided a sample.
Thanks & regards
So, if the fourth line was something like this
how would I know that I need I Like QlikView or Like QlikView or just QlikView?