topic Re: getting two fields in a same table in QlikView

getting two fields in a same table

Anonymous — Wed, 13 Sep 2017 12:27:44 GMT

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 — Wed, 13 Sep 2017 12:33:54 GMT

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

prieper — Wed, 13 Sep 2017 12:38:52 GMT

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 — Wed, 13 Sep 2017 12:41:05 GMT

these tables are linked via one of the field ,

how to do that

not getting

its_anandrjs — Wed, 13 Sep 2017 12:53:51 GMT

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 — Wed, 13 Sep 2017 12:57:40 GMT

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