I have a source with some columns and if i unpivot few columns actual structure will be lost. But i need to keep the actual source and in addition to the actual source, i need the unpivoted columns also.
I am thinking of creating another source and merge. Is there any better way to do this?
If I understand it correctly, you have created a query to get data, you want to keep this source result also want to get the transformed (use unpivoted feature) data, right?
In your scenario, you can open Query Editor, duplicate the original query, then in the copy, perform the unpivoted column action. In this way, you will have two queries, the original query and transformed query.
It depends on the row data, you can merge those two queries or not. But please remember there should be a common column field between those two queries to perform Merge Queries.