Data Modelling

[krishna20]

Hi Folks,

I got struck on a requirement in the modelling part.

Tab1

A

B

C

D

E

F

Tab2

1

2

3

4

5

Tab3

abc

def

ghi

jkl

mno

I'm having three tables which is linked properly. (here i have not mentioned the key).

When i click on the value 'A' in Tab1, the possible values in Tab2 is '2' and in Tab3 is 'ghi'.

I need to restrict the value 'A' from Tab1 and the possible values to it.(The value 'A' need to hide)

The values '2' and 'ghi' from tab2 and tab3 may be a possible values to another values in the tab1.

I need to restrict only for 'A' from tab1 .

Please suggest me some logic to restrict the data.

Regards

Krishna

[ramasaisaksoft]

Hi Krishna,

Case1 :just call except 'A' column from Table1

Case2: Change all values in column 'A' is '0'

[avinashelite]

you need to restrict the values in the load script or the front end ??

[krishna20]

I need to restrict the values in the load script Avinash.

[MayilVahanan]

Hi

Are you want to remove 'A' from tab1?

Load * from table1 where Tab1 <> 'A';

[amayuresh]

Option 1: Ignore A values in Tab 1 during loading.

Option 2: put condition to avoid A values at UI level

[tyagishaila]

=if( not wildmatch(Dimension, 'A' ), Dimension)

Here Dimension is whatever dimension for 'A' in Tab1

[krishna20]

Hi Mayil,

I restrict the value A, from tab1, by using where condition Tab1<>'A'.

but the possible values still showing in Tab2 and Tab3 .

[tyagishaila]

Do you want to hide A?

or

you want to restrict possible value of A...

to understand/resolve issue share  qvw file.

[MayilVahanan]

Hi

Do you want to remove those values also? If so, you exists function..

Load * from table1 where Tab1 <> 'A';

Load * from table2 where exists(KeyFieldFromtable1, KeyFieldFromTable2);

or

Use Keep function

Load * from table1 where Tab1 <> 'A';

Left Keep

Load * from table2;

It load the data only based on table 1...

Hope it helps