Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new at using QlikView, so sorry if this is a stupid question.
I have data in an excel spreadsheet. I want to standardize some text strings upon loading the data into Qlik.
Text string examples:
I want to standardize all text strings that contain "AMZN" to be "Amazon"
Is there a way to accomplish this?
Thanks for the help.
Hi, for this example it could be something like: If(WildMatch(FieldName,'AMZN*'),'Amazon') as StandarizedText
Hi, for this example it could be something like: If(WildMatch(FieldName,'AMZN*'),'Amazon') as StandarizedText