String comparison

[gokulnath2592]

Hi all,

I want to compare string between two table and display result in a straight table.

for example table 1 has  

Colors

Red

Blue

Green

Table 2 has same field as color

Red

Blue

Green

yellow

Here table 2 has extra data as yellow .

In a straight table i want to display yellow only.

please provide solution for this.

Thanks,

Gokul

[MK_QSL]

T1:

Load *, 'No' as Flag From TableName1;

T2:

Load *, 'SameColor' as Flag From TableName2 Where Exist (ColorFIeld);

Load *, 'DifferentColor' as Flag From TableName2 Where Not Exist (ColorFIeld);

Now create a List Box with below exrepsson

If(Flag = 'DifferentColor', ColorField)

[#3]

Hi,

Load Colors from Table 1 to Table 2 with Color as Key.

A:

Mapping Load

Colors as Color,

Colors

resident Table 1;

Table2:

Load *,

Applymap('A', Color, 'NA')  as ColorMap

from Table2:

> In Straight Table dimension,

if(ColorMap='NA',color)

Regards,

Joshmi