flag compare two table

[MauriceLudo]

Hello,
All codes in Table A are not necessarily present in table B
I would like to add a new type of field flag contennant EMC 'for the codes in both tables and' NO EMC 'for others.
Thank you for your help
cordially
Maurice

[avinashelite]

could you please share the sample data for the same??

[MauriceLudo]

I can send you in private if you wanted

[avinashelite]

I don't need any confidential data

just like this would be enough

Table1:

A,B,C

1,A,aa

2,B,cc

so that we could get an idea how is the data linked and what the comparison we need to do 

[MauriceLudo]

the two fields to be compared in the table  TIERS and CRM_CLIENTS

[vinieme12]

Use ApplyMap to flag available codes in each table

TableA_Codes

MAPPING LOAD

     DISTINCT Codes,

     'InA' as Flag

FROM TABLEASOURCE;

TableB_Codes

MAPPING LOAD

    DISTINCT Codes,

     'InB' as Flag

FROM TABLEBSOURCE;

///NOW Add FLAGS TO YOUR Tables

TABLEA:

LOAD *,

Applymap('TableB_Codes',Codes,'NotInB') as CodeFlag

FROM TABLEASOURCE;

TABLEB:

LOAD *,

Applymap('TableA_Codes',Codes,'NotInA') as CodeFlag

FROM TABLEBSOURCE;

Hope it helps !

[vinieme12 · Accepted solution]

See attached

[MauriceLudo]

Nice , thank you very much Vineeth

[MauriceLudo]

Hi vinieme12 , please can you help me optimize an application, I made several handling but I have not managed to reduce the response time.

thank you

[vinieme12]

Hi Maurice,

By response time do you mean dashboard performance or data reload time?

This depends on many things, I will need to look into your app and understand your dataset to suggest anything.

How many rows of data you are dealing with?

Is there something in particular that is causing a problem like a pivot/straight table/ chart?