cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vkomarag Member
Member

Can i have actual columns and unpivoted columns as part of same source

Hi,

 

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?

 

Thanks

KVB

3 REPLIES 3
dedelman_clng New Contributor
New Contributor

Re: Can i have actual columns and unpivoted columns as part of same source

Can you provide a sample of your data, both how it starts out and what you hope for it to look like?

vkomarag Member
Member

Re: Can i have actual columns and unpivoted columns as part of same source

I am preparing data. My bad. Having pivoted and unpivoted data in the same source might impact the results.

Sorry.Reverting my question,

Moderator v-qiuyu-msft
Moderator

Re: Can i have actual columns and unpivoted columns as part of same source

Hi @vkomarag,

 

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.

 

q5.PNG

 

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.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.