Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

QVX join QVD

Hello Community,

I am trying to join two tables with the same key, one table has been extract from Informatica (QVX) and the other by QV script (QVD).

When I load this two tables, the data model is good (my tables are linked by the key) but insight my QlikView data are not linked !

It is probably a data format setting somewhere in Informatica setting for my extraction, but I didn't find any topic about this :s

The attache file show the issue.

Thanks community to help me,


ps: Sorry for my poor english (I am french guy)

4 Replies
Valued Contributor

Re: QVX join QVD

I see that there is an additional space after each of the enreies in the upper section of the table...

You can check with LEN(ID_QV).

You can also check with... Left(ID_QV,1)


Check how this part of the datset is created.. and see.. if these spaces are getting added when they are laoded into the system...

hope that helps..

Not applicable

Re: QVX join QVD

Hi sebastien,

Surely You have Link these two tables but not even single entry is common between this two.See the subset ratio of associated field of both the tables.Its showing 50% each.

And as Aadil point out correctly please  correct the data format so that they will match.



Not applicable

Re: QVX join QVD

Thanks for your qwick feedback, you right !

I check my Informatica QV target and my key should be in 12 and not 13 !


So I still not know how this space could be in my key !


Not applicable

Re: QVX join QVD

Hello guys,

I still have my issue on some other dataset... Like the join tables show, when I compare two dataset (QVX vs QVD). I can see an unknow character (some time at begining, some other at the end) whitch is not always remove with trim() fonction...

I am sure it's a parameter on Informatica extraction format but I can't find it :s... Does someone already use Informatica extraction et could show me how to solve this ?


Community Browser