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