To link 2 tables in a graph, when there is no link in the loader

[Anonymous]

Hi

I have 2 tables that are no linked

QV_TOU_CONTACT

CONTACT_NUM

TEL_1 (format exemple 06020202)

TEL_2

QV_TIKAL

DATE

TEL_TIKAL_1 (format exemple 3306020202)

TEL_TIKAL_2

USER

I have done the graphic bellow, from the table QV_TIKAl :

DATE     USER     TEL_TIKAL_1     TEL_TIKAL_2

I want to add the column CONTACT_NUM from CONTACT_NUM when

TEL_TIKAL_1=TEL_1 or =TEL_2

or

TEL_TIKAL_2=TEL_1 or =TEL_2

How can I do this ?

Thanks

[stigchel]

You can use Set Analysis:

Concat({<TEL_TIKAL_1={'$(=TEL_1)','$(=TEL_2)'}>} CONTACT_NUM)

See also attached qvw

[Anonymous]

Thanks

But in the table QV_TIKAL, the phone number has a prefix 33 that is not in the table QV_TOU_CONTACT

How to use 'like' function in the syntax that you wrote ?

Regards

[stigchel]

Use wildcard search characters:

Concat({<TEL_TIKAL_1={'??$(=TEL_1)','??$(=TEL_2)'}>} CONTACT_NUM)

[Anonymous]

Hi

Sorry but it doesn't work

attached, my file if you can help me please

Thanks

[stigchel]

Your qvw is password protected... and I don't have the password. But see my attached where it is working

[Anonymous]

I don't understand

it may be works because you have just one line in each table

see my document please (Login : LA / pwd : 1205)

Thanks

[stigchel]

I would advice you to still link the tables in the load script by creating a unique key (checking if '33' is there or not and adding it if it is not). If must you can use the following expression (you still need to expand it, but I hope you get the idea, it works for the example you had selected: (33)0699362611)

if(isnull(FieldValue('CONTACT_NUM', FieldIndex('TEL_PORTABLE',TIKAL_DESTINATAIRE))),FieldValue('CONTACT_NUM', FieldIndex('TEL_PORTABLE',right(TIKAL_DESTINATAIRE,10))),FieldValue('CONTACT_NUM', FieldIndex('TEL_PORTABLE',TIKAL_DESTINATAIRE)))

[Anonymous]

Thanks a lot

[Anonymous]

Hi

After some verifications, it seems that it's not work well

I recover a num contact but it's no the good one

Reagrds