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

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 Memorable Member
Memorable Member

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 Helper III
Helper III

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,

Community Support
Community Support

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.

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors