Modify Sales Refresh, add CSHSCM table and get CSANBR (Channel_Code), add Table Input to get the date from the reference table sales_channel the merge the query from the Sales in JDA and merge the data from sales_channel, add If value is null step to put a hard code value (Walk in) all the Channel_Code without value on the sales_channel. Test and publish on the server 172.16.11.124