topic Mapping load help in QlikView

Mapping load help

stevelord — Thu, 13 Oct 2016 23:26:46 GMT

Hi All, I have text strings with commas I need to map to text strings without commas. Please advise. Thanks!

Example:

I want this:

Acme 2016 - Walk 10,000 Steps - March

to go to this:

Acme 2016 - Walk 10000 Steps March

But the comma in the first 10,000 breaks the mapping for that line.

I have a mapping load with several hundred rows of stuff stripping the second hyphen to help a subfield action in a dashboard, but the commas in the last few strings are holdouts.

Re: Mapping load help

stevelord — Thu, 13 Oct 2016 23:32:14 GMT

Just googled and found people say use single or double quotes around the string. (It was an inline load example, but should be fine.)

Re: Mapping load help

MarcoWedel — Thu, 13 Oct 2016 23:35:22 GMT

please provide some more sample data of your mapping table and raw data yo uwant to apply the map to.

Relevant parts of your script might help as well.

regards

Marco