I have a script but i dont want to write where condition in this script
i have dimensions like these
there is 3 types of people now i want only 3 type in table but i dont want to put where condition in script because this table is associated with other tables so i am trying to filter it out on TYPE dimension how i done this
any help ?
no i dont want like that i want to filter it our on dimension not on script ..
i have data like this
i add dimension TYPE then from that i only want 3
i dont want to where condition in script
type is TYPE is same ..
look there is the data in TYPE column I.E. 1,2,3 now i want 3 type in my data like with this i have a separate columns from different tables
name country address type
abc US none 1
xyz UAE abc_address 3
def MAL gh_Address 2
and so on data
now i add script like this
load name , country , address type from abc_file
and on the other tab
load type,typename from type_file
now if i only want data type 3 is supposed to write script like this
load name , country , address type from abc_file where type=3
but i dont want like this
i add table then i add dimensions i.e. name and type so now on that type dimension how i add where condition ?