I dont want to have particular location for a particular user.

[#1]

My task is in Account_Categories_loop.qvw we don’t want to have ship_to_location_num  as 80 for a particular user_id=’duchow_jim’

But I checked in Teradata for the same query  as given below

select distinct ship_to_location_num, ship_to_CUSTOMER_NUM from ship_to_account
where
acct_key_num in(
select distinct acct_key_num from account_user_rlt
where
mrcry_user_id=(select mrcry_user_id from mercury_user
   where
   user_id='duchow_jim'
   )

)

This query is not showing any ship_to_location_num as 80 for a particular user_id=’duchow_jim’

[Agis-Kalogiannis]

I assume that the ship_to_location_number is your DC # field.

But the value 80 is associated with the specific user according to your dataset

If I am wrong, can you please give us some more details?

Thanks

Agis