Solution was using Lateral View Explode but I approached in a CASE WHEN and UNION ALL which was not accepted because The interview panel guy only wanted to accept solution which he had in his mind.