Matching two columns- when QS doesn't recognize formats

[jasmina_karcic]

Hi guys,

I have one column that is the same in 3 sources. This column is relation between some tables.

One source is oracle database, second is excel doc, and third is in data model.

Format of this column is text. I am matching, but one value cannot be matched....I cannot find where is problem....

How can I see where is problem in matching?

Thanks,

Jasmina

[PabloTrevisan]

Hi Jasmina,

is probably in the format of each source .. I have already gone through this with fields in the data format ... First try to find out which source is not matching and then take an action, I have a hunch it is in excel = P

[jasmina_karcic]

I have solved something, but not all...

For example: If I have database and excel, than I load data from database and make export data to excel. Then I take this text from exported excel and I copy field to a new excel that I need....and it works....:/

I did this now, but all didn't match...:/

One makes me a problem...:D

[PabloTrevisan]

I believe that this is not the best alternative, the ideal is to format via script for both fonts have the same format in the data model, can you make me available .qvf, excel file and a .qvd, to try to help you?

[qlik4asif · Accepted solution]

Hi Jasmina,

Did you tried with Autonumber Function?

This function will create unique number for each distinct value. And also better to use trim function to remove extra spaces before Autonumber.

[jasmina_karcic]

Greta!!!

Trim function is what I needed. Thank you very much.

Now I will read about autonumber, to see what this will give. Thank you again.

Jasmina