I had few data sources and it has few data in columns that is more than 15 characters (approx 18). So while loading them I am getting ambiguous values and last 4 digits are different.
Data in excel sheet is as per below:
After loading in qlikview I am getting below data:
I can't modify the data as it is a legacy data any way around to solve this?
You haven't said what this data is, so here is a wild guess.
Excel is treating this data as a number and is rounding.
QV reads the number and displays rounded differently.
Perhaps converting the number in Excel to a label and then reading into QV as a string?
Some sample Excel data might help resolve this issue.