data showed as duplicated

mohammadnabi — Tue, 13 Jul 2021 20:29:09 GMT

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

Re: data showed as duplicated

mohammadnabi — Sun, 18 Jul 2021 11:58:47 GMT

i found the solution

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