Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two values in excel under one column like ABC,abc.
Here the problem is, In excel it is considering both as one value where as Qlik sense considering two because it is a case sensitive.
For this how can I update the value ABC to abc in Qlik sense to overcome the issue?
So that I can able to consider only abc in Qlik sense.
BR,
Upendra Reddy Mekala
That's an open-ended question since you haven't explained how you recognize the values that you want to be changed. If you only want to change 'ABC' then you could use e.g.
If(Field = 'ABC','abc',Field) as Field
Or you could create a list of things you want to change and use either Pick/WildMatch or a mapping load. However, that does require some way of picking out the specific values you want changed, of course.
If you aren't interested in case sensitivity, you could use either Upper(Field), Lower(Field), or Capitalize(Field), whichever one you prefer.
For specific values(ABC to abc) only I want to change not all the field values.
Is there any way to change?
That's an open-ended question since you haven't explained how you recognize the values that you want to be changed. If you only want to change 'ABC' then you could use e.g.
If(Field = 'ABC','abc',Field) as Field
Or you could create a list of things you want to change and use either Pick/WildMatch or a mapping load. However, that does require some way of picking out the specific values you want changed, of course.
Hi Or,
I tried with if(), I got the required output, Thank you.
Regards,
Upendra Reddy Mekala