Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
mohammadnabi
Contributor II
Contributor II

data showed as duplicated

hello dear community,

i want to load the list of IT assets that includes name, user, IMEI and so on.

i have two different sources with different information, the link between them is IMEI.

i load one of the data from oracle DB which is dynamic, and one from an excel file which is static.

the problem is, when i link two sources by IMEI (which is the only option) i get them duplicated and separated to each other.

it shows excel file IMEIs as a text field, and DB IMEI as Nvarchar2 data type.

i tried to change both ( and each of them) to text and num, but doesn't help.

highly appreciated if anyone could help

1 Solution

Accepted Solutions
mohammadnabi
Contributor II
Contributor II
Author

i found the solution

using TEXT format, and creating the QVD files, will help over this process

View solution in original post

1 Reply
mohammadnabi
Contributor II
Contributor II
Author

i found the solution

using TEXT format, and creating the QVD files, will help over this process