Skip to Content
0

Check records, comparison

Feb 22, 2017 at 12:58 PM

29

avatar image

Ok I write it a simpler (easy).

I have t_contact.firstname from table t_contact. How is way for solution check string? I have second table list of official name t_name.name and when I write {t_contact.firstname} = {t_name.name} refresh is very very long time. OR it is possible add index to xlsx table for fastes refresh?

thanks

names.jpg (229.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Marek Moravcik Feb 24, 2017 at 09:51 AM
0

I thought too join this 2 tables but refresh is very slow and write this condition:

IF {t.name_name}={t_contact.s_firstname} then "True" else "False"

Join is slowly because missing index table xlsx t_name

Share
10 |10000 characters needed characters left characters exceeded