how to match fields for two different table

[ameydiwanji]

Hi,

I am creating a calculated field in the table, and while doing so i want to match the value of one of the column in my existing table with value to column in other table, but i a am unable to see the other table.

For eg:

If(match([New ARN Code], (i want to match the values of this column with values of column in other table)

But i can see any other table

[rubenmarin]

Hi Maey, it's hard to folow your intentions,

There is the option the check values loaded by other tables using exists:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/InterRecordFun...

Another way to access values from other tables can be using:

-Applymap: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/MappingFunctio...

- Joins tables:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

- Lookup: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/InterRecordFun...