Skip to Content

Check records, comparison

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 24, 2017 at 09:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded