getting two fields in a same table

[Anonymous]

how to get the two fields from difffernt table

as i need to create a flag comparing the values of these two fields ,

[its_anandrjs]

If there is  relation between this tables and with fields also you can create another link table to get another fields.

[prieper]

Your question is very unspecific, can you post an example?

In general there must be any kind of link between these fields.

Within an application then you may simply use a formula like IF(A = B, 'equal', 'not equal')

Within scripting you need to bring these fields together, mapping might be a possibility, or joining these tables.

mapA: MAPPING LOAD Key, A RESIDENT ...;

CombinedTable: LOAD *, IF(A = B, 'equal', 'not equal') AS Check; LOAD Key, B, APPLYMAP('mapA', Key) AS A .... FROM ...;

[Anonymous]

these tables are linked via one of the field ,

how to do that

not getting

[its_anandrjs]

Better you post and sample.

1. This two fields you want in different table.

2. After getting in different table will it connected to previous table or not.

[karthikoffi27se]

Hi Dy,

You can create a flag under each table.

TABLE1

LOAD *,

'First Table' as Flag1

;

TABLE2

LOAD *,

'Second Table' as Flag2

;

Please use the above expression.

Many Thanks

Karthik