Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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