Trump abandons the effort but directs the Commerce Department to explore other avenues for question.