Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We recently upgraded from SAP Connector 5.4 to the latest 6.5.
Main change was the treatment of fields that accept both numeric and string entries.
We changed the connection string parameter MixedMode to TRUE and this made the transition for most of our built extractors bearable.
Except for 1 so far. Extracting from SAP table KNA1.
For some reason under MixedMode TRUE, customer code (KUNNR) P434 and 434 is treated as the same.
I tried changing MixedMode to FALSE and this separated the values.
Can anyone please give clarification?
Thanks.
1. Yes I believe they are, haven't checked for all possible data types though.
2. I haven't tried this out myself so no good answer there, needs experimenting...
3. One thing you could try is to test an application named EasyQlik QViewer, it's not a Qlik product but I've found it convenient for looking at QVD files and what different metadata is assigned on different levels. You can see the unknown flag in the XML Type metadata field.
But I don't think using MixedMode=true is a bad thing, if you have fields with mixed content it makes a lot of sense using it (and utilizing Qlik's 'intelligence'). But it can be too 'broad', i.e what you saw in detecting values as money. So if you want better control and know for example that there's only text or numeric values you could use MixedMode=false and trying Num#() function on the values and falling back on text.
4. Yes but probably hard to cover for all different probing that Qlik does (i.e numeric, money, dates, times, etc.) so depending on your situation.
// Thomas Örnmarker